TG: sql_for_qa/94

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

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

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

2.5K viewsMay 19, 2023 at 11:12

tg-me.com/sql_for_qa/94

Create: 2023-05-19
Last Update: 2025-07-02 13:49:35

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

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

NEWS: Telegram supports Facetime video calls NOW!

Secure video calling is in high demand. As an alternative to Zoom, many people are using end-to-end encrypted apps such as WhatsApp, FaceTime or Signal to speak to friends and family face-to-face since coronavirus lockdowns started to take place across the world. There’s another option—secure communications app Telegram just added video calling to its feature set, available on both iOS and Android. The new feature is also super secure—like Signal and WhatsApp and unlike Zoom (yet), video calls will be end-to-end encrypted.