database 1, written answer please
Posted: Sat Feb 19, 2022 3:22 pm
database 1, written answer please
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)
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)