SQL_CodeBasics/sql4.4.sql at main · suyogghate/SQL_CodeBasics · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
USE moviesdb;

SELECT title, industry FROM movies;

SELECT * FROM movies;

SELECT *
FROM movies
WHERE industry = 'Bollywood';

SELECT count(*)
FROM movies
WHERE industry = 'Hollywood';

SELECT distinct
industry FROM movies;

SELECT *
FROM movies
WHERE title LIKE '%AMERICA%';

SELECT *
FROM movies
WHERE studio = '';

--  Print all movie titles and release year for all Marvel Studios movies.
SELECT title, release_year
FROM movies
WHERE studio = 'Marvel Studios';

-- Print all movies that have Avenger in their name.
SELECT *
FROM movies
WHERE title LIKE '%Avenger%';

-- Print the year when the movie "The Godfather" was released.
SELECT release_year
FROM movies
WHERE title = 'The Godfather';

-- Print all distinct movie studios in the Bollywood industry.
SELECT distinct
studio FROM
movies
WHERE industry = 'Bollywood';