SQL для тестировщика

Даны 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;



B) 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;



C) 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;



D) 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;



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