4. What DJs on Demand d_play_list_items song_id's have the same event_id as song_id 45?
5. Which events in the DJs on Demand database cost more than event_id = 100?
6. What is the staff type for those Global Fast Foods jobs that have a salary less than those of any Cook staff-type jobs?
7. Find the last names of all employees whose salaries are the same as the minimum salary for any department.
8. Which Global Fast Foods employee earns the lowest salary? Hint: You can use either a single-row or a multiple-row subquery.
9. Using a WITH clause write a SELECT statement to list the job_title of those jobs whose maximum salary is more than half the maximum salary of the entire company. Name your subquery MAX_CALC_SAL. Name the columns in the result JOB_TITLE and JOB_TOTAL, and sort the result on JOB_TOTAL in descending order.
Hint: Examine the jobs table. You will need to join JOBS and EMPLOYEES to display the job_title.