SQL для тестировщика on Telegram: “Дана таблица orders с колонками order

Дана таблица 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;

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;

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