【task02】–sql进击小队-基础查询与排序

1.创建数据库、表

CREATE DATABASE shop;

CREATE TABLE product (
	product_id CHAR ( 4 ) NOT NULL,
	product_name VARCHAR ( 100 ) NOT NULL,
	product_type VARCHAR ( 32 ) NOT NULL,
	sale_price INTEGER,
	purchase_price INTEGER,
regist_date DATE,
PRIMARY KEY ( product_id ));