SQL184大厂面试真题
统计连续2天及以上在该店铺购物的用户及其对应的次数
代码如下：
select distinct s.user_id, count(distinct s.sales_date) from sales_tb s join
(
select user_id, sales_date from sales_tb
where (user_id, sales_date+1) in (select user_id, sales_date from sales_tb)
)t using(user_id)
group by s.user_id
order by s.user_id ASC
查看24道真题和解析