SQL-练习

attend表，字段如下
num,no,attendance
工号、工资编号、出勤率

employee表，字段如下
num,name,sex,age,departmentno
工号、姓名、性别、年龄、部门

wage表，字段如下
no,amount
编号、工资金额

题目：
–1.查询工资金额为8000的职工工号和姓名，降序排列
–方式一
select employee.num, employee.name from employee, attend
where attend.no in (select DISTINCT no from wage where amount = 8000)
and attend.num = employee.num ORDER BY employee.num desc
–方式二
select num, name from employee where EXISTS (
select num from attend WHERE EXISTS ( select DISTINCT no from wage where amount = 8000 and attend.no = wage.no)
and employee.num = attend.num)
ORDER BY employee.num desc

–2.查询张三的出勤率
–方式一
select attendance from attend where exists(
select num from employee where name=”张三”
and attend.num = employee.num)
–方式二
select attendance from attend where