SQL

Question 4 Use the tables in your schema. Your boss was at a company party and met a fellow employee whose last name was Olson, or Olsen, or something else like that. He wasn't quite sure (his hearing is bad when he drinks). He wants you to run a query that will get the first and last name of all employees whose last name sounds like Olson, along with and the name of the department for which they work. He is sure once he sees the name and department he will remember the person. Make sure you use a function to check for the sound of the name. Use both SQL/86 and SQL/92. */ -- SQL/86 -- -- SQL/92 with ON -- -- SQL/92 with USING -- HR DEPARTMENTS department_id department name manager_id location_id LOCATIONS location_id street_address postal_code city state_province country_id JOB_HISTORY employee_id start_date end_date job_id department_id TY EMPLOYEES employee_id first_name last_name email phone_number hire_date job_id salary commission_pct manager_id department_id COUNTRIES country_id country_name region_id JOBS job_id job_title min_salary max_salary REGIONS region_id region_name