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;
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;
Соседние файлы в папке Схемы и SQL код