**Exercise 6.1.2**: Write the following queries, based on our running movie database exampleTables:- `Movies(title, year, length, genre, studioName, producerC#)`- `StarsIn(movieTitle, movieYear, starName)`- `MovieStar(name, address, gender, birthdate)`- `MovieExec(name, address, cert#, netWorth)`- `Studio(name, address, presC#)`---**6.1. SIMPLE QUERIES IN SQL**Write the following queries in SQL:a) Find the address of MGM studios.b) Find Sandra Bullock’s birthdate.c) Find all the stars that appeared either in a movie made in 1980 or a movie with "Love" in the title.d) Find all executives worth at least $10,000,000.e) Find all the stars who either are male or live in Malibu (have string Malibu as a part of their address).

According to Bartleby Guidelines we need to answer only three sub questions so I have answered first three sub questions in step 2 :- Please post remaining questions separatelySolution :- a) Find the address of MGM studios. Answer:- SQL query select address from MovieExec where name = "MGM"; b) Find Sandra Bullock's birthdate. Answer:- SQL query select birtdate from MovieStar where name = "Sandra Bullock"; c) Find all the stars that appeared either in a movie made in 1980 or a movie with "Love" in the title. Answer:- SQL query select m.name from StarsIn s join MovieStar m on s.starName = m.name where movieYear = "1980" or movieTitle like "%Love%";