BNU: BSc in Computing
CO558: Database Design
Relational Database using SQL
Week 10 Activities - SQL SELECT with Join
| Task |
Lesson Activity |
Learning Assessment |
Skill Developed |
| 10.1 |
-
PPT 30 min
SQL Syntax
-
5 min
List all Staff Details
-
5 min
List all Staff Details who work at Branch B3
-
5 min
Find all the properties registered at Branch B3
-
5 min
Find all the property details for those properties looked after by staff member SG14.
-
5 min
List the name and address of all managers.
Display the results in alphabetical order of LastName
-
10 min
List the names and addresses of all non-managers
-
10 min
List the address area, city, number of rooms and rent for those properties which are houses.
Display the results in order of lowest rental
-
10 min
List staff name and position for those members of staff who earn less than £20,000.
Display the results from highest to lowest salary.
|
|
SQL Queries
|
Useful Resources