select city,driver_id,avg_grade,avg_order_num,avg_mileage from( select city, driver_id, round(avg(grade),1) avg_grade, round(count(tb_get_car_order.driver_id)/count(distinct date(order_time)),1) avg_order_num, round(sum(mileage)/count(distinct date(order_time)),3) avg_mileage, rank()over(partition b...

select answer_date, author_id, count(issue_id) from answer_tb where month(answer_date)= 11 group by answer_date, author_id having count(issue_id) >=3 order by answer_date, author_id

select tag, sum(if_retweet) retweet_cnt, round(sum(if_retweet)/count(tu.video_id),3) retweet_rate from tb_user_video_log tu join tb_video_info tv on tu.video_id = tv.video_id where datediff((select max(start_time) from tb_user_video_log ),tu.start_time) < 30 group by tag order by retweet_rate des...

select answer_date, round(count(issue_id)/count(distinct author_id),2) per_num from answer_tb group by answer_date order by answer_date

select ct.course_id, ct.course_name, round(sum(if_sign=1)/sum(if_vw=1)*100,2) as 'sign_rate(%)' from course_tb ct join behavior_tb bt on bt.course_id = ct.course_id group by ct.course_id, ct.course_name