1084 销售分析III
题目链接:1084.销售分析III
解答
select p.product_id,product_name from Product p
left join Sales s on p.product_id=s.product_id
group by product_id
having min(s.sale_date)>='2019-01-1'
and max(s.sale_date)<='2019-03-31';
1141 查询近30天活跃的用户数
题目链接:1141.查询近30天活跃的用户数
解答
select activity_date day,count(distinct user_id) active_users from Activity
group by activity_date having datediff('2019-07-27',activity_date)<30
and datediff('2019-07-27',activity_date)>=0;
最后,我写了一篇MySQL教程,里面详细的介绍了MySQL的基本概念以及操作指令等内容,欢迎阅读!
MySQL数据库万字保姆级教程