Дана таблица orders с колонками order_id

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

SELECT MONTH(order_date) AS month, SUM(total_amount) AS total_order_amount
FROM orders
GROUP BY month
ORDER BY total_order_amount DESC
LIMIT 3;

SELECT EXTRACT(MONTH FROM order_date) AS month, SUM(total_amount) AS total_order_amount
FROM orders
GROUP BY month
ORDER BY total_order_amount DESC
LIMIT 3;

SELECT DATE_TRUNC('month', order_date) AS month, SUM(total_amount) AS total_order_amount
FROM orders
GROUP BY month
ORDER BY total_order_amount DESC
LIMIT 3;

SELECT STRFTIME('%Y-%m', order_date) AS month, SUM(total_amount) AS total_order_amount
FROM orders
GROUP BY month
ORDER BY total_order_amount DESC
LIMIT 3;

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

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

2.7K viewsMay 4, 2023 at 07:34

tg-me.com/sql_for_qa/89

Create: 2023-05-04
Last Update: 2025-07-02 16:21:07

Дана таблица orders с колонками order_id, customer_id, order_date, total_amount. Какой из следующих SQL запросов вернет топ-3 месяца с наибольшим количеством заказов?

A) SELECT MONTH(order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;B) SELECT EXTRACT(MONTH FROM order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;C) SELECT DATE_TRUNC('month', order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;D) SELECT STRFTIME('%Y-%m', order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;Ответить на вопрос можно ниже ⬇️

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/89

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

Дана таблица orders с колонками order_id