Question: sQL Query Practice I The following query statements are based on Company database in class note EMPLOYER DEPT LOCATIONS WORKS ON DEPENDENT NAM RELATIONSHIP Query
sQL Query Practice I The following query statements are based on Company database in class note EMPLOYER DEPT LOCATIONS WORKS ON DEPENDENT NAM RELATIONSHIP Query 0: List the last name of male employees. Query 0-1: List the first name, middle name and last name of employees who born on December 8, 1995. Query 0-2: List the first name and last name of employees who earn $50,000 minimum salary (more than $50,000). Query 1: List the birthdate and address of the employee whose name is Tom G Brand'. Query 1-1: List the location of department no 8. Query 1-2: List the name and location of projects which department no 5 manages. Query 1-3: List the name of spouse of all employees. Query 2: Retrieve social security numbers for all employees. Query 2-1: List all different last names of employees. Query 3: List the social security numbers of all employees who work on project number 1, 2, or 3. Query 3-1: List the name and salary of employees who work for department number 4, 5, or 6. Query 4: List the names of all employees who do not have supervisors. Query 5: List all employees whose address is in Atlanta, GA. Query 6: List all employees who were born during the 1960s. (use LIKE) Query 6-1: List all employees who were born during the 1960s. (use BETWEEN AND) Query 6-2: List employees who first name is between 'Apple' and 'Bee
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
