7. Assume there is a payment history table with a column cal…
7. Assume there is a payment history table with a column called payment_type that indicates if a payment is regular salary, a bonus, or an award. What question does this correlated query answer? Begin your answer with “This query answers the question: who are the employees…” SELECT employee_id, first_name, last_nameFROM employees e1WHERE NOT EXISTS (SELECT ph.lastname FROM payment_history ph WHERE ph.emp_id = e1.employee_idAND ph.payment_type =’award’)
Read Details