1.
create database xscj;2.
use xscj;3.
source C:\Users\Administrator\Desktop\sy81.sql
4.
create database yggl;5.
use yggl;6.
source C:\Users\Administrator\Desktop\sy82.sql
7.
select 学号,姓名,课程号,成绩 from xs_kc join xs using (学号) where 课程号 ='101' and 成绩 >=80;8.
select 学号,姓名,课程号,成绩 from xs join xs_kc using (学号);9.
select kc.课程号,课程名,成绩 from kc,xs_kc where kc.课程号 = xs_kc.课程号;10.
use yggl;11.
select salary.编号,姓名,收入-支出 as 工资 from employees join salary using (编号);12.
select 编号,姓名,部门名称 from departments join employees using(部门号) where 姓名 ='王林';