0130 Learning, reading and blogging

📱 Responded to another headhunter and learned some Python

🖥️ Learned Python all the morning

⌨️ Built a Movie Ticket Booking Calculator! (Python Basics: 43 of 73 steps complete)

🛌 Took a nice nap

📖 13:06 Started reading The Giver chapter 3

💭 The book is still a little difficult for me right now.

📘 14:40 Finised reading chapter 3

📝 Wrote January summary

㊗️ Asked Gemini for help and successfully added a monthly archive to this blog.

📖 Started reading 『刻意练习』

🖥️ Started learning SQL

JOIN will combine rows from different tables if the join condition is true.
LEFT JOIN will return every row in the left table, and if the join condition is not met, NULL values are used to fill in the columns from the right table.
Primary key is a column that serves a unique identifier for the rows in the table.
Foreign key is a column that contains the primary key to another table.
CROSS JOIN lets us combine all rows of one table with all rows of another table.
UNION stacks one dataset on top of another.
WITH allows us to define one or more temporary tables that can be used in the final query.