Дана таблица 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;
Дана таблица 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
In many cases, the content resembled that of the marketplaces found on the dark web, a group of hidden websites that are popular among hackers and accessed using specific anonymising software.“We have recently been witnessing a 100 per cent-plus rise in Telegram usage by cybercriminals,” said Tal Samra, cyber threat analyst at Cyberint.The rise in nefarious activity comes as users flocked to the encrypted chat app earlier this year after changes to the privacy policy of Facebook-owned rival WhatsApp prompted many to seek out alternatives.
Telegram Be The Next Best SPAC
I have no inside knowledge of a potential stock listing of the popular anti-Whatsapp messaging app, Telegram. But I know this much, judging by most people I talk to, especially crypto investors, if Telegram ever went public, people would gobble it up. I know I would. I’m waiting for it. So is Sergei Sergienko, who claims he owns $800,000 of Telegram’s pre-initial coin offering (ICO) tokens. “If Telegram does a SPAC IPO, there would be demand for this issue. It would probably outstrip the interest we saw during the ICO. Why? Because as of right now Telegram looks like a liberal application that can accept anyone - right after WhatsApp and others have turn on the censorship,” he says.
