SHOW DATABASES

CREATE DATABASE shops;

USE shops

CREATE TABLE shop (

id INT(11) PRIMARY KEY,

TYPE VARCHAR(30),

NAME VARCHAR(50),

price DECIMAL(10,2),

num INT,

TIME DATETIME

);

INSERT INTO shop (id, TYPE, NAME, price, num, TIME)

VALUES(1, '饮品', '绿茶', 25.50, 100, '2023-10-01 08:30:00'),

(2, '书籍', '水浒传', 79.80, 50, '2023-09-15 10:00:00'),

(3, '糖类', '牛奶糖', 12.90, 200, '2023-08-20 14:20:00'),

(4, '服饰', '纯棉 T 恤', 99.00, 30, NULL),

(5, '饮品', '红茶', 5.50, 150, '2023-06-05 09:15:00'),

(6, '书籍', '西游记', 68.00, 40, '2023-05-23 11:30:00'),

(7, '糖类', '水果糖', 8.50, 250, '2023-04-12 15:00:00'),

(8, '服饰', '牛仔裤', 299.00, 20, '2023-03-08 17:20:00'),

(9, '饮品', '鲜橙汁', 15.00, 120, '2023-02-25 10:45:00'),

(10, '书籍', '红楼梦', 45.20, 60, '2023-01-16 14:30:00');

SELECT COUNT(*) FROM shop

SELECT SUM(num) FROM shop

SELECT AVG(price) FROM shop

SELECT MAX(price) FROM shop

SELECT MIN(num) FROM shop

SELECT * FROM shop WHERE num>50

SELECT * FROM shop WHERE NAME LIKE'%果%'

SELECT * FROM shop ORDER BY TIME

SELECT * FROM shop LIMIT 1,3

SELECT TYPE,COUNT(*) FROM shop GROUP BY TYPE