SQL
- [SQL][LeetCode] 1280. Students and Examinations - LEFT OUTER JOIN + INNER JOIN + GROUP BY + SCALAR SUBQUERY MYSQL 2024.12.06
- [SQL][LeetCode] 577. Employee Bonus - LEFT OUTER JOIN + MYSQL 2024.12.05
- [SQL][LeetCode] 1661. Average Time of Process per Machine - INNER JOIN + SCALAR SUBQUERY MYSQL 2024.12.05
- [SQL][LeetCode] 1581. Customer Who Visited but Did Not Make Any Transactions - NOT EXISTS + LEFT OUTER JOIN + GROUP BY + IS NULL + COUNT MYSQL 2024.12.04
- [SQL][LeetCode] 1068. Product Sales Analysis I - INNER JOIN MYSQL 2024.12.04
- [SQL][LeetCode] 197. Rising Temperature - INNER JOIN + EXISTS + NL SEMI JOIN + DATE_ADD(INTERVAL) MYSQL 2024.12.03
- [SQL][LeetCode] 1378. Replace Employee ID With The Unique Identifier - LEFT OUTER JOIN + SCALAR SUBQUERY MYSQL 2024.12.03
- [SQL][LeetCode] 1683. Invalid Tweets - CHAR_LENGTH + LENGTH MYSQL 2024.12.03
- [SQL][LeetCode] 1148. Article Views I - DISTINCT + EXISTS + GROUP BY MYSQL 2024.12.03
- [SQL][LeetCode] 1757. Recyclable and Low Fat Products - SELECT MYSQL 2024.12.03
- [SQL][LeetCode] 584. Find Customer Referee - SELECT + IS NULL MYSQL 2024.12.03
- [SQL][LeetCode] 595. Big Countries - SELECT MYSQL 2024.12.03
- [SQL][LeetCode] 570. Managers with at Least 5 Direct Reports - INNER JOIN + GROUP BY + HAVING ORACLE 2024.10.22
- [SQL][HackerRank] Placements - INNER JOIN ORACLE 2024.10.17
- [SQL][HackerRank] Contest Leaderboard - INNER JOIN + SUBQUERY + MAX + GROUP BY ORACLE 2024.10.16
- [SQL][HackerRank] Challenges - INNER JOIN + SUBQUERY + MAX + COUNT + GROUP BY ORACLE 2024.10.15
- [SQL][HackerRank] Ollivander's Inventory - INNER JOIN + SUBQUERY + MIN ORACLE 2024.10.15
- [SQL][HackerRank] The Report - INNER JOIN + BETWEEN + CASE WHEN + SORT ORACLE 2024.10.15
- [SQL][HackerRank] Top Competitors - INNER JOIN + COUNT + GROUP BY + DISTINCT ORACLE 2024.10.13
- [SQL][HackerRank] Weather Observation Station 20 - MEDIAN + ROUND ORACLE 2024.10.13
- [SQL][HackerRank] New Companies - INNER JOIN + DISTINCT ORACLE 2024.10.13
- [SQL][HackerRank] Binary Tree Nodes - CASE WHEN + NOT IN + NULL ORACLE 2024.10.12
- [SQL][HackerRank] Draw The Triangle 2 - ALTERNATIVE QUERIES + CONNECT BY + RPAD ORACLE 2024.10.12
- [SQL][HackerRank] Draw The Triangle 1 - ALTERNATIVE QUERIES + CONNECT BY + RPAD ORACLE 2024.10.12
- [SQL][HackerRank] African Cities - INNER JOIN + ROUND ORACLE 2024.10.10
- [SQL][HackerRank] African Cities - INNER JOIN ORACLE 2024.10.10
- [SQL][HackerRank] Population Census - INNER JOIN + SUM ORACLE 2024.10.10
- [SQL][HackerRank] Weather Observation Station 19 - ROUND + POWER + SQRT + 유클리드 거리(EUCLIDEAN DISTANCE) ORACLE 2024.10.09
- [SQL][HackerRank] Weather Observation Station 18 - ROUND + ABS + MIN + MAX ORACLE 2024.10.09
- [SQL][HackerRank] Weather Observation Station 17 - ROUND + MIN + INNER JOIN + SUBQUERY + GROUP BY ORACLE 2024.10.09