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.

From the Salesm an and Customer tables below, write SQL statements to do the following: a) List the sales man id, rating and names of those sales men who getrating from 3 to 5, sorted DESCENDING by rating. b) List all the customers' informat ion whose name starts with 'F' and the fourth character is T, rests may be any charac ter. c) List the name andcountry of those customers and sales men who belongs to the same country. Salesman table: Salesman Salesman_ rating _id country name 2001 Mc Lyon 3 Italy 2005 James hood 2 Canada 2045 Paul Hen USA 2010 Nail Alex 4 France 2060 Salm E 5 KSA Cust omer table: Cust_id Cust_nam grade country Salesman e _id 1 Nick 100 France 2010 Rimando 2 Brad Davis 400 Canada 2005 3 Fabian 200 Japan 2045 Johnson 4 UK Jozy Altidor 100 2010 5 Brad Guzan 500 Canada 2005

All foreign language results should be rated Fails to Meet. a) True b) False

please fast its database

How is an ADT put together, exactly? Indicate your answer where indicated.

Determine the kind of books that are currently in stock. Each category should be represented by a single item.

(vii) Show the (car) types and the frequency at which each type has been used. Show most frequently used types first.   (viii) Show the emails of users who have paid more than 600 dollars for their rides.   (ix) Show the shortest and the longest rides (in terms of duration). (You can use two queries for this purpose.)

Third normal form says:   a. No nonkey columns depend on another nonkey column.   b. Every column that's not part of the primary key is fully dependent on the primary key.   c. Eliminate repeated fields.   d. None of the above.

It is necessary to use an Oracle function in order to determine the number of days that have elapsed between your birthday and the current date.

java, using lyrics database