编辑代码

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;