데이터 공부를 기록하는 공간

■ 코드카데미(codecademy) SQL 연습해보기 https://www.codecademy.com/courses/learn-sql/lessons/multiple-tables/exercises/generalizations-multiple-tables ■ Cheating Sheets https://www.codecademy.com/learn/learn-sql/modules/learn-sql-multiple-tables/cheatsheet LESSON 4 : MULTIPLE TABLES JOIN (= Inner Join, 교집합) SELECT * FROM books JOIN authors ON books.author_id = authors.id; LEFT JOIN (= Outer Join) SELECT c..