Page 1 of 1

database 1, written answer please

Posted: Sat Feb 19, 2022 3:22 pm
by answerhappygod
database 1, written answer please
Database 1 Written Answer Please 1
Database 1 Written Answer Please 1 (28.89 KiB) Viewed 54 times
1) Using the COMPANY schema, express the following queries in SQL. Your queries should always work without modification even if the underlying tables change via insert/update/delete operations. 1.1 Find the first name and salary of all male employees. (1 point) 1.2 For each employee, find the employee first name and the project number he/she works on. (2 points) 1.3 Find the department name that has exactly three locations. (2 points)