Assignment-1
Query1:
SELECT *
FROM netflix.`netflix_originals - netflix_originals`
WHERE IMDBScore > 7
AND Runtime > 100
AND (Language = 'English' OR Language = 'Spanish');
Query-2
SELECT Language, COUNT(*) AS title_count
FROM netflix.`netflix_originals - netflix_originals`
GROUP BY Language
HAVING COUNT(*) > 5;
Query-3
SELECT Title, Runtime
FROM netflix.`netflix_originals - netflix_originals`
WHERE Language = 'Hindi'
ORDER BY Runtime DESC
LIMIT 3;
Query-4
SELECT Title, IMDBScore
FROM netflix.`netflix_originals - netflix_originals`
WHERE Title LIKE '%House%'
AND IMDBScore > 6;
Query-5
SELECT Title
FROM netflix.`netflix_originals - netflix_originals`
WHERE Premiere_Date BETWEEN 2018 AND 2020
AND Language IN('English', 'Spanish', 'Hindi');
Query-6
SELECT *
FROM `netflix_originals - netflix_originals`
WHERE (Runtime < 60 OR IMDBScore < 5)
ORDER BY Premiere_Date;
Query-7
SELECT GenreID, AVG(IMDBScore) AS avg_IMDBScore
FROM netflix.`netflix_originals - netflix_originals`
GROUP BY GenreID
HAVING COUNT(*) >= 10;
Query-8
SELECT Runtime, COUNT(*) AS Runtime_count
FROM netflix.`netflix_originals - netflix_originals`
GROUP BY Runtime
ORDER BY Runtime_count DESC
LIMIT 5;
Query-9
SELECT Language, COUNT(*) AS Title_count
FROM netflix.`netflix_originals - netflix_originals`
WHERE Premiere_Date = 2020
GROUP BY Language;
Query-10
