[SQL] 기본 Queries

■ 코드카데미(codecademy) SQL 연습해보기

https://www.codecademy.com/courses/learn-sql/

■ Cheating Sheets

https://www.codecademy.com/learn/learn-sql/modules/learn-sql-queries/cheatsheet

LESSON 2 : QUERIES

---

SELECT

SELECT name, genre, year
FROM movies;

---

AS

SELECT imdb_rating AS "IMDb"
FROM movies;

---

DISTINCT

SELECT DISTINCT year
FROM movies;

---

WHERE

SELECT * 
FROM movies
WHERE year > 2014;

---

LIKE BETWEEN

SELECT *
FROM movies
WHERE name LIKE 'Se_en';

SELECT *
FROM movies
WHERE name LIKE 'The %';

SELECT * 
FROM movies
WHERE year BETWEEN 1970 AND 1979;

---

AND OR

SELECT name
FROM movies
WHERE imdb_rating IS NULL;
### WHERE imdb_rating IS NOT NULL;

---

ORDER BY

SELECT name, year, imdb_rating
FROM movies
ORDER BY imdb_rating DESC;

---

LIMIT

SELECT *
FROM movies
ORDER BY imdb_rating DESC
LIMIT 3;

---

CASE

SELECT name,
    CASE 
        WHEN genre = 'romance' 
            OR 'comedy' THEN 'Chill'
        ELSE "Intense"
    END AS "Mood"
FROM movies;

---