2019.12.4 leetcode SQL

1112 每位学生最高成绩

Select student_id,min(course_id) as course_id,grade
From Enrollments
Where(student_id,grade) in (
Select student_id,max(grade) as grade
From Enrollments 
Group by student_id) 
Group by student_id
Order by student_id ASC

两次（ ） in （ ）
两次Group by ！ 这个很重要哦，不然答案就尴尬了

1107 每日新用户统计

SELECT login_date, COUNT(user_id) user_count FROM 

    (
        SELECT user_id, MIN(activity_date) AS login_date
        FROM Traffic
        WHERE activity = 'login' 
        GROUP BY user_id
    )temp
    
WHERE login_date >= DATE_SUB('2019-06-30',INTERVAL 90 DAY)

GROUP BY login_date

注意Date_sub（‘’，INTERVAL 90 DAY）
1126

Select s3.business_id 
From (
    Select *,count(*) as num
    From Events s1
    Join(
        SELECT e1.event_type, AVG(e1.occurences) as AVG_occurences
        From Events e1
        Group by e1.event_type) s2
    on s1.event_type = s2.event_type
    WHERE s1.occurences > s2.AVG_occurences
Group by s1.business_id
) s3
Where s3.num >= 2

我觉得可对他觉得错了系列