241106_TIL

아무리 사소하더라도 배움이 없는 날은 없다.

SQL 문제풀이 복습

Leetcode

문제 링크

SELECT COUNT(a.account_id) AS "accounts_count"
FROM   (SELECT account_id
        FROM   Subscriptions
        WHERE  YEAR(end_date) = '2021') a
       JOIN Streams s
         ON a.account_id = s.account_id
            AND YEAR(stream_date) <> '2021';

문제 링크

SELECT problem_id
FROM   (SELECT problem_id,
               likes,
               dislikes
        FROM   Problems
        GROUP  BY 1
        HAVING 100.0 * likes / ( likes + dislikes ) < 60) a
ORDER  BY 1;

문제 링크

SELECT c.candidate_id
FROM   Candidates c
       JOIN (SELECT interview_id,
                    SUM(score) AS "total_score"
             FROM   Rounds
             GROUP  BY 1
             HAVING total_score > 15) a
         ON c.interview_id = a.interview_id
WHERE  c.years_of_exp >= 2;