sql solutions for chapter 5
data from test database
back
5.2 names of all workers in the accounting department in the test database:
first name |
last name |
Tom | Smith |
Mary | Jones |
Jane | Burns |
George | Washington |
james | madison |
5.3 alphabetical listing of names of all workers assigned to project 1001:
first name |
last name |
Jane | Burns |
Amanda | Chin |
Mary | Jones |
Tom | Smith |
5.4 employee in the research dept. with the lowest salary:
first name |
last name |
john | adams |
5.5 details of the project with the highest budget:
project number |
project name |
project manager id |
budget |
start date |
expected duration weeks |
number of employees assigned |
1025 | Neptune | 110 | 600000.00 | 2015-02-01 | 45 | |
5.6 names and departments of workers on project 1019:
first name |
last name |
department name |
Michael | Burns | Research |
Amanda | Chin | Research |
5.15 details of any project with 'urn' in its name:
project number |
project name |
project manager id |
budget |
start date |
expected duration weeks |
number of employees assigned |
1005 | Saturn | 101 | 400000.00 | 2014-06-01 | 35 | |