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

SQLQUESTIONS Telegram 926

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

Create: 2023-03-22
Last Update: 2025-07-13 22:48:51

Задача 21

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

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

#задача

BY SQL задачи

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

Open in Telegram

Telegram News

Date: 2025-07-13|

The creator of the channel becomes its administrator by default. If you need help managing your channel, you can add more administrators from your subscriber base. You can provide each admin with limited or full rights to manage the channel. For example, you can allow an administrator to publish and edit content while withholding the right to add new subscribers. 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. Clear Deputy District Judge Peter Hui sentenced computer technician Ng Man-ho on Thursday, a month after the 27-year-old, who ran a Telegram group called SUCK Channel, was found guilty of seven charges of conspiring to incite others to commit illegal acts during the 2019 extradition bill protests and subsequent months. To upload a logo, click the Menu icon and select “Manage Channel.” In a new window, hit the Camera icon.
from us

Telegram SQL задачи
FROM American