Telegram Group & Telegram Channel
Дана таблица "orders" c колонками "order_id", "customer_id", "order_date" и "total_amount". Какой из следующих SQL запросов выведет общую сумму заказов в разрезе покупателей?
Anonymous Quiz
SELECT customer_id, COUNT(order_id) FROM orders GROUP BY customer_id;
SELECT customer_id, AVG(total_amount) FROM orders GROUP BY customer_id;
SELECT customer_id, MAX(total_amount) FROM orders GROUP BY customer_id;
SELECT customer_id, SUM(total_amount) FROM orders GROUP BY customer_id;
542 answered
🔥12👍63



tg-me.com/sql_for_qa/94
Create:
Last Update:

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

View MORE
Open in Telegram


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

Date: |

Telegram is riding high, adding tens of million of users this year. Now the bill is coming due.Telegram is one of the few significant social-media challengers to Facebook Inc., FB -1.90% on a trajectory toward one billion users active each month by the end of 2022, up from roughly 550 million today.

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


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