#MySQL #tutorial #course SELECT first_name, last_name, hourly_pay, (SELECT AVG(hourly_pay) FROM employees) AS avg_payFROM employees;SELECT first_name, last_nameFROM customersWHERE customer_id IN (SELECT DISTINCT customer_idFROM transactions WHERE customer_id IS NOT NULL);