SQL задачи@sqlquestions P.924

SQLQUESTIONS Telegram 924

SQL задачи

Задача 21

Напишите запрос, чтобы найти продавцов, создавших заказы на максимальные и минимальные суммы по каждой отдельной дате.

Верните salesman_id, name, order_no, строку highest on или lowest on (т.е. наибольшая или наименьшая сумма на [определенное число], ord_date. Отсортируйте результат по третьему полю, т.е. по номеру заказа.

#задача

www.tgoop.com/sqlquestions/925

2.91K viewsMar 22, 2023 at 17:37

tgoop.com/sqlquestions/924

Create: 2023-03-22
Last Update: 2025-07-13 14:07:44

Задача 21

Напишите запрос, чтобы найти продавцов, создавших заказы на максимальные и минимальные суммы по каждой отдельной дате.

Верните salesman_id, name, order_no, строку highest on или lowest on (т.е. наибольшая или наименьшая сумма на [определенное число], ord_date. Отсортируйте результат по третьему полю, т.е. по номеру заказа.

#задача

BY SQL задачи

Share with your friend now:
tgoop.com/sqlquestions/924

Open in Telegram

Telegram News

Date: 2025-07-13|

Healing through screaming therapy Telegram channels enable users to broadcast messages to multiple users simultaneously. Like on social media, users need to subscribe to your channel to get access to your content published by one or more administrators. Hashtags are a fast way to find the correct information on social media. To put your content out there, be sure to add hashtags to each post. We have two intelligent tips to give you: A Hong Kong protester with a petrol bomb. File photo: Dylan Hollingsworth/HKFP. A few years ago, you had to use a special bot to run a poll on Telegram. Now you can easily do that yourself in two clicks. Hit the Menu icon and select “Create Poll.” Write your question and add up to 10 options. Running polls is a powerful strategy for getting feedback from your audience. If you’re considering the possibility of modifying your channel in any way, be sure to ask your subscribers’ opinions first.
from us

Telegram SQL задачи
FROM American