Exercise 1
Last updated
Was this helpful?
Last updated
Was this helpful?
Create a Database named IMDB
Download the SQL file from and run the code present in it inside the IMDB
database.
(Make sure that the tables are created inside IMDB
database only)
Write an SQL statement to display all the records from the movies
table
Write 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 the genre
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 the genre
value is Invalid Genre
Write an SQL statement to delete all the records where movie_id
is 32217 and the genre
is Sport
Write an SQL statement to display all the records where domestic earning is greater than 100000 and worldwide earning is less than 9000000