编辑代码

create database ep;
use ep;

create table employees(
    bh int,
    xm char(255),
    xb int,
    rq date,
    sr int,
    jj int
);
INSERT INTO  employees VALUES (0010001, '张子婷',0,'2018-5-18', 4700,1800);
INSERT INTO  employees VALUES (0010002, '张伟泽',1,'2018-5-18', 4500,110);
INSERT INTO  employees VALUES (0020001, '王文诺',0,'2019-5-1', 4500,900);
INSERT INTO  employees VALUES (003002,   '赵天成',1,'2019-12-1', 4400,550);
INSERT INTO  employees VALUES (0010003, '岳晓',0,'2018-5-19', 3000,1200);
INSERT INTO  employees VALUES (0010004, '王怡文', 0,'2018-5-19', 4600,1100);
INSERT INTO  employees VALUES (0010005, '李梦龙',1,'2018-5-19', 4600,1300);
INSERT INTO  employees VALUES (0010006, '张宁',1,'2018-5-19', 4700,1000);
INSERT INTO  employees VALUES (0010007, '徐子文',1,'2018-5-19', 4500,800);
INSERT INTO  employees VALUES (0010008, '李天路',1,'2018-6-2', 3500,700);
 
SELECT * FROM employees;

CREATE TABLE sales(
xsbh char(255),
bh int,
sl int,
spbh char(255)
);
INSERT INTO sales VALUES ('0010001',0010001,2,'0001');
INSERT INTO sales VALUES ('0010001',0010002,1,'0010');
INSERT INTO sales VALUES ('0010001',0020001,4,'0012');
INSERT INTO sales VALUES ('0010001',0010002,3,'0100');
INSERT INTO sales VALUES ('0010001',0010003,2,'0001');

select*from sales;
select xm,sales.bh,sl from sales,employees where sales.bh=employees.bh;
select sales.bh,xm,sl,spbh from sales inner join employees using(bh);
select xm,sl from employees join sales using(bh) where s1>2;
select xm,sl from employees join sales using(bh) order by(sl);
select xm,sales.bh,sl,商品编号,商品名称 from employees join sales using(bh)
join stocks on sales.spbh=stocks.商品编号;
select xm,sales.bh,slfrom employees left join sales on emp