Exercise 1
Create a Database named
IMDB
Download the SQL file from this link and run the code present in it inside the
IMDB
database. (Make sure that the tables are created insideIMDB
database only)Write an SQL statement to display all the records from the
movies
tableWrite an SQL statement to display the count of the rows in the
movies
table.Write an SQL statement to display all the
genre
values in thegenre
table in capital letters.Write an SQL statement to display all the records in the genre table that has an
space
in the genre value.Write an SQL statement to display all the records in the movies table in the movie names starting with
##
and also---
Write an SQL statement to update all the movie names where the name starts with
##
or also---
and remove the##
and---
Write an SQL statement to delete all the records in the
genre
table where thegenre
value is Invalid GenreWrite an SQL statement to delete all the records where
movie_id
is 32217 and thegenre
is SportWrite an SQL statement to display all the records where domestic earning is greater than 100000 and worldwide earning is less than 9000000
Last updated