CREATE DATABASE test;
use test;
CREATE TABLE TABLE4 (
STOCK VARCHAR(50),
SYMBOL CHAR(6),
SHARETYPE CHAR(1),
PRICE DECIMAL(10,2),
PROVINCE VARCHAR(50)
);
SELECT * FROM TABLE4;
SELECT STOCK, SYMBOL FROM TABLE4;
SELECT STOCK, SYMBOL, PRICE FROM TABLE4 WHERE PRICE BETWEEN 30 AND 100 ORDER BY PRICE DESC;
CREATE TABLE TABLE6 (
Stkcd CHAR(6),
Trddt DATE,
Opnprc DECIMAL(10,2),
Clsprc DECIMAL(10,2),
Dnshrtrd INT
);
SELECT Dnshrtrd FROM TABLE6 WHERE Stkcd = '603903';
SELECT Stkcd, Opnprc FROM TABLE6;
SELECT Stkcd, Trddt, Dnshrtrd FROM TABLE6 WHERE Clsprc BETWEEN 10 AND 20 ORDER BY Dnshrtrd DESC;