- Database 1 Written Answer Please 1 (28.89 KiB) Viewed 52 times
database 1, written answer please
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
database 1, written answer please
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)