Даны 2 таблицы с названиями orders и products c колонками "order_id"

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

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;

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

www.tg-me.com/id/SQL для тестировщика/com.sql_for_qa/164

1.4K viewsAug 14, 2023 at 11:30

tg-me.com/sql_for_qa/164

Create: 2023-08-14
Last Update: 2025-07-02 13:47:16

Даны 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;Ответить на вопрос можно ниже ⬇️

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

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/164

SQL для тестировщика Telegram | DID YOU KNOW?

Даны 2 таблицы с названиями orders и products c колонками "order_id"