SQL퀘스트(2)

> 정답

25. Select satisfaction_score
    RANK()OVER(ORDER BY satisfaction_score DESC) -->>??
    From lol_feedbacks
26. (답안 참고)
    SELECT id, user_name, satisfaction_score, feedback_date
    FROM lol_feedbacks
    ORDER BY satisfaction_score DESC;
27. Select MAX(날짜_컬럼) COUNT() user_name ,
    feedback_date —>>??
    From lol_feedbacks
28. (답안 참고)
    SELECT user_name, MAX(feedback_date)
    FROM lol_feedbacks
    GROUP BY user_name;
29. Select satisfaction_score COUNT —>>??
    From lol_feedbacks
30. (답안 참고)
    SELECT COUNT(*)
    FROM lol_feedbacks
    WHERE satisfaction_score = 5;
31. Select id ,
    user_name ,
    satisfaction_score ,
    feedback_date
    From lol_feedbacks
32. (구글링)
    Order by salary DESC
    LIMIT 3;
33. (답안 참고)
    SELECT user_name, COUNT(*) AS feedback_count
    FROM lol_feedbacks
    GROUP BY user_name
    ORDER BY feedback_count DESC LIMIT 3;
34. Select avg (satisfaction_score) as Count LIMIT feedback_date
    From lol_feedbacks
35. (구글링_TOP 절 사용)
    Select TOP 1 avg(satisfaction_score) , feedback_date
    From lol_feedbacks
36. (답안 참고)
    SELECT feedback_date
    FROM lol_feedbacks
    GROUP BY feedback_date
    ORDER BY AVG(satisfaction_score) DESC LIMIT 1;