Problem
I. List all of the inspections done by employees with ids of 173558 or 171336. Show inspection ID, Date, and Type.
II. What is the monthly salary for each employee that is a Supervisor? List first name, last name and monthly salary. Label the answer column as Monthly_Salary.
III. Make a list of the types of inspections for food establishments and sort the output ascending. (Avoid duplicates.)
IV. Provide a list of all food establishments that also sell gas. (Establishments that have the word 'Gas' in the facility type.) Show in your answer DBA Name and Facility Type. Sort the output by DBA Name.
V. Provide a report of all data for employees whose salary is 50,000 or greater and less than or equal to 70,000. Use BETWEEN.