Consider the following schema. The following relations keep track of Movie information. Movie (title, year, length, incolor, studio_name, producer) Stars_In ( movie_title, movie_year, star_name)...

Extracted text: Consider the following schema. The following relations keep track of Movie information. Movie (title, year, length, incolor, studio_name, producer) Stars_In ( movie_title, movie_year, star_name) Movie_star (name, address, gender, birthdate) MovieExec ( name, address, cert, networth) Studio ( name, address, cert, networth) Write the following queries using SQL. 1.Find all the star's name who appears either in a movie made in 1980 or a movie with "love" in the title. 2.Find all executives worth at least 10, 00000$. 3.Find the movies that are longer than "Terms of Endearment" movie. 4.Find the executives who worth more than MGriffin. 5.Find all stats that either are male or live in Miami