q2.sql [30] /* Company database
List the last name of the manager for the project ‘Computerization’ along with the number of work assignments for this project.
Result: (1 row) LNAME Projects
Wallace 3
*1
q3.sql [25] /* Company database
List the name of project(s) managed by the ‘Research’ department with the total number of work hours assigned to each of these projects.
Result: (1 row) PNAME TotalHours
ProductX 52.5 ProductY 37.5 ProductZ 50.0
*1