具体可查看:https://www.bilibili.com/video/BV1RV41147Tb/?spm_id_from=333.999.0.0&vd_source=3ba3c3ba31427f60d734ede7a948de4a
join实现
select u.name, o.orderid from order o join user u on o.id = u.id;
实现思路
distinct 实现
select dealid,count(distinct uid) from order group by dealid;
实现思路
group by实现
select rank,isonline,count(*) from order group by rank,isonline;
实现思路