客户表a(id name address) 登陆流水表b(id time) 购物流水表c(id time productid productnum)
1.求每个客户的最新登陆时间time姓名name客户id
2.查最新登陆并且已经购买商品的客户idname登陆的时间time(一条sql语句)
一个表student中有班级classid学号id成绩grade
1.计算各个班的平均成绩
2.查找比该班平均成绩高的学生的班级classid学号id成绩grade
1.求每个客户的最新登陆时间time姓名name客户id
select a.ida.named.time as time
from a left join (select idmax(time) as time from b group by id) d
on a.id =d.id ;
2.查最新登陆并且已经购买商品的客户idname登陆的时间time(一条sql语句)
select a.ida.named.time as time
from a(select idmax(time) as time from b group by id) d
where a.id =d.id
and exists (select * from c where id = a.id);
1.计算各个班的平均成绩
select classidavg(grade)
from student
group by classid;
2.查找比该班平均成绩高的学生的班级classid学号id成绩grade
select a.classida.ida.grade
from student a
where a.grade >(select avg(grade) from student where classid = a.classid);