Tag: 프로그래머스
All the articles with the tag "프로그래머스".
-
Programmers SQL #3 — Having two tables doesn't mean writing FROM twice
I ran into a problem with two tables for the first time. Writing FROM twice didn't work, so I solved it with a subquery using IN. JOIN gives the same answer.
-
Programmers SQL #2 — Sorting Isn't sort, It's ORDER BY
The second problem was easy to solve. When I thought of sorting, sort came to mind first, but in SQL it's ORDER BY. I also used multi-column sorting for the first time, something I only knew conceptually before.
-
Programmers SQL #1 — SELECT · FROM · WHERE have an order
I started solving Programmers problems to study SQL. On the first problem I hit a syntax error because I didn't follow clause order, then worked through it by looking up AS · AVG · ROUND one by one.