SQL для тестировщика on Telegram: “Даны 2 таблицы с названиями orders и products c…”

Даны 2 таблицы с названиями orders и products c колонками "order_id", "customer_id", "product_id", "order_date", "quantity" и "product_id", "product_name", "unit_price". Какой из следующих SQL запросов вернет топ-5 покупателей, которые потратили больше всего в категории "Electronics"?

A)

SELECT o.customer_id, SUM(o.quantity * p.unit_price) AS total_spent
FROM orders o JOIN products p ON o.product_id = p.product_id
WHERE p.product_name LIKE '%Electronics%'
GROUP BY o.customer_id
ORDER BY total_spent DESC
LIMIT 5;

SELECT o.customer_id, SUM(o.quantity * p.unit_price) AS total_spent
FROM orders o JOIN products p ON o.product_id = p.product_id
WHERE p.product_id IN (SELECT product_id FROM products WHERE product_name LIKE '%Electronics%')
GROUP BY o.customer_id
ORDER BY total_spent DESC
LIMIT 5;

SELECT o.customer_id, SUM(o.quantity * p.unit_price) AS total_spent
FROM orders o JOIN products p ON o.product_id = p.product_id
WHERE p.product_id IN (SELECT product_id FROM products WHERE product_name LIKE 'Electronics%')
GROUP BY o.customer_id
ORDER BY total_spent DESC
LIMIT 5;

SELECT o.customer_id, SUM(o.quantity * p.unit_price) AS total_spent
FROM orders o JOIN products p ON o.product_id = p.product_id
WHERE p.product_id IN (SELECT product_id FROM products WHERE product_name = 'Electronics')
GROUP BY o.customer_id
ORDER BY total_spent DESC
LIMIT 5;

Ответить на вопрос можно ниже ⬇️