Tag: sql
All the articles with the tag "sql".
-
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.
-
SQL Data Cleaning — Coffee and coffee Are Different Values (Data Engineering Study #1)
I started studying data engineering. Two days of notes on deliberately creating a dirty CSV to see how case sensitivity and empty values break aggregations, plus the principle of never touching raw data and cleaning it in staging instead, and learning UPPER, CASE, and COALESCE.