第二题暴力解
select uid from user_info where gender='女' and age<='25' and uid in (select uid from user_video where date>='20190801' and date<='20190807' and tag=='美食' group by uid having count(uid)>10) and uid in (select uid from user_video where date=='20190808' and tag=='美食' group by uid having count(uid)<3)
第三题
select distinct tag, max(cnt) over (partition by tag)-min(cnt) over (partition by tag) from (select tag, uid, count(uid) cnt from user_video group by tag, uid)
第一题求大佬
突然发现个问题,他所有的字段都是varchar的……包括年龄这种数字