#MySQL #tutorial #course
SELECT first_name, last_name, hourly_pay,
(SELECT AVG(hourly_pay) FROM employees) AS avg_pay
FROM employees;
SELECT first_name, last_name
FROM customers
WHERE customer_id IN (SELECT DISTINCT customer_id
FROM transactions WHERE customer_id IS NOT NULL);
Published 2022-11-12 · Watch on YouTube ↗ Availability and playback restrictions are controlled by the original channel.
05:39
