# Exercise 1

1. Create a Database named `IMDB`
2. Download the SQL file from [this link](https://arbrecreations-my.sharepoint.com/:u:/g/personal/mrinmais_arbre_in/EUF1TWUESkhIruCqyTw8NpoBB_9Ld2FFJm2JK76OydCOqQ?e=POeYlp) and run the code present in it inside the `IMDB` database.\
   (Make sure that the tables are created inside `IMDB` database only)
3. Write an SQL statement to display all the records from the `movies` table
4. Write an SQL statement to display the count of the rows in the `movies` table.
5. Write an SQL statement to display all the `genre` values in the `genre` table in capital letters.
6. Write an SQL statement to display all the records in the genre table that has an `space` in the genre value.
7. Write an SQL statement to display all the records in the movies table in the movie names starting with `##` and also `---`
8. Write an SQL statement to update all the movie names where the name starts with `##` or also `---` and remove the `##` and `---`
9. Write an SQL statement to delete all the records in the `genre` table where the `genre` value is **Invalid Genre** 
10. Write an SQL statement to delete all the records where `movie_id` is **32217** and the `genre` is **Sport**
11. Write an SQL statement to display all the records where domestic earning is greater than **100000** and worldwide earning is less than **9000000**