1. Create an ORACLE 11g query displaying last_name, department_id, salary, commission_pct aliased as comm_pct, and the commission amount (salary multiplied by commission_pct, when commission_pct is null, replace it with a zero) aliased with comm_amt. Show only those records for departments that are located in cities not starting with the letter s. * Note city is not a column in employees table but in locations table and the primary key is not found in the employees table but it is in the departments table. In short l.location_id = d.location_id d_department_id = e.department_id