문제 입력 코드SELECT ROUND(SUM(TIV_2016),2) AS tiv_2016FROM insuranceWHERE tiv_2015 IN (SELECT tiv_2015 FROM insurance GROUP BY tiv_2015 HAVING COUNT(pid) > 1) AND (lat, lon) IN (SELECT lat, lon FROM insurance GROUP BY lat, lon HAVING COUNT(pid) = 1); 코드 설명#SELECT #ROUND #SUM #GROUP BY #HAVING #COUNT #IN 문제 출처https://leetcode.com/problems/investments-in-2..
문제 입력 코드1. (SELECT name AS resultsFROM MovieRating JOIN Users USING(user_id)GROUP BY nameORDER BY COUNT(*) DESC, nameLIMIT 1)UNION ALL(SELECT title AS resultsFROM MovieRating JOIN Movies USING(movie_id)WHERE EXTRACT(YEAR_MONTH FROM created_at) = 202002GROUP BY titleORDER BY AVG(rating) DESC, titleLIMIT 1); 2. WITH TheMostActiveUser AS ( SELECT name FROM Users NATURAL JOIN ..
문제 입력 코드1. SELECT CASE WHEN id = (SELECT MAX(id) FROM Seat) AND (id % 2 = 1) THEN id WHEN id % 2 = 1 THEN id + 1 ELSE id - 1 END AS id, studentFROM SeatORDER BY id; 2. SELECT S.id, IFNULL( IF(S.id % 2 = 0, (SELECT student FROM Seat WHERE id = S.id - 1), (SELECT student FROM Seat WHERE id = S.id + 1) ..