SQL Solutions for Chapter 5

5.3 Names of all workers in the Accounting department

First Name Last Name
TomSmith
MaryJones
JaneBurns


5.4 Alphabetical listing of names of all workers assigned to project 1001

First Name Last Name
JaneBurns
AmandaChin
MaryJones
TomSmith


5.5 Employee in the research dept. with the lowest salary

First Name Last Name
JamesMonroe


5.8 View that shows project numbers and their managers

Project Number Mgr Last Name Mgr First Name Employee ID Emp Last Name Emp First Name
1001SmithTom101SmithTom
1001SmithTom103JonesMary
1001SmithTom105BurnsJane
1001SmithTom115ChinAmanda
1005SmithTom103JonesMary
1019BurnsMichael110BurnsMichael
1019BurnsMichael115ChinAmanda
1025BurnsMichael110BurnsMichael
1030BurnsMichael110BurnsMichael