write the sql quries for below given schema...?

Question

movies(title,year,length,gender,studioname,producerc#)
starIn(movietitle,movieyear,starname)
moviestar(name,adress,gender,birthdate)
movieexec(name,address,cert#networth)
studio(name,address,pressc#)
questions: 1. Find all stars that appeared either in a movie in 1990 or a movie with 'love' in titles?
2. Find all the stars who either are made or live in malibu( have string malibu as part of there address)?

plz help me out....

Answer 1

I'll walk you thru the method I ususally use to formulate this sort of query on the first one:



First, find all movies made in 1990: SELECT title FROM movies WHERE year = 1990



Next, all movies with 'love' in title: SELECT titile FROM movies WHERE TO_LOWER(title) LIKE "%love%"



Finally, combine the two resultsand list the stars (removing duplicates):

SELECT DISTINCT starname FROM starIn WHERE movietitle IN

(SELECT DISTINCT title FROM movies

WHERE year = 1990 OR TO_LOWER(title) LIKE "%love%")

Answer 2

Teach yourself at SQL Exercises: http://www.sql-ex.com/

Answer 3

Need to know what your PK and FK are?