Question: Using the COMPANY schema, express the following queries in SQL . For each query, include the query text and output. 1 ) Find the first

Using the COMPANY schema, express the following queries in SQL. For each query, include the query text and output.
1) Find the first name, middle initial, and last name of all employees whose salary is not 30000.(1 point)
2) Find the first name, middle initial, last name, and address of all employees whose last name does not end with the letter g.(1.5 point)
3) Find the locations of the Research department.
(1.5 point)
4) Find the first name, last name, and salary of all employees whose salary is the lowest. (2 points)
5) For each employee, retrieve the employee SSN and the number of dependents the employee has ordered by the employee SSN in ascending order. (1.5 points)
Using the COMPANY schema, express the following

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!