Схемы и SQL код / Лабораторная №4 ИБД Поиск записей

SHOW DATABASES;
USE order;
SHOW TABLES;

SELECT * FROM products;
SELECT product_ID, p_name FROM products;

SELECT * FROM clients;
SELECT client_ID, c_name FROM clients WHERE с_name_company="NikeShop";

SELECT * FROM deals;
SELECT * FROM deals ORDER BY deal_client_ID;
SELECT deal_time FROM deals ORDER BY deal_time DESC;

SELECT * FROM deals;
SELECT deal_ID, deal_time FROM deals ORDER BY deal_number DESC LIMIT 3;
SELECT deal_ID, deal_time FROM deals ORDER BY deal_number DESC LIMIT 3,3;

SELECT * FROM delivery;
SELECT COUNT(delivery_ID) FROM delivery;
SELECT COUNT(DISTINCT delivery_ID) FROM delivery;

SELECT * FROM products;
SELECT MAX(p_opt) AS maximum, MIN(p_opt) AS minimum FROM products;