第一题:
select a.gname ,b.gprice from goods a join (select gno from goods where gprice>30) b on b.gno=a.gno where gname =’%商%’ or gname = ‘s%’ or gname=‘F%’
第二题
select sdate from goods join sc on goods.gno=sc.gno where a.gprice*b.amount order by sc.uno desc limit 100
数据库
1 select * from employee where between 100 and 200( 包括边界值)
2 select * from employee where name like ‘王%’
3 select team_id, count(id) from employee group by team_id
4 select a.id,a.name,b.team_id,b.‘人数’ from employee a inner join (select team_id,count(id) as ‘人数’ from employee group by team_id ) b on a.team_id = b.team_id
- select name from score where group