What would be the SQL Oracle Queries to solve these questions

Get perfect grades by consistently using www.assignmentgeeks.org. Place your order and get a quality paper today. Take advantage of our current 20% discount by using the coupon code GET20


Order a Similar Paper Order a Different Paper

Use your common sense on these. Show the SQL query. DO NOT provide IDs in the final answer; all answers should be meaningful. Be careful; a movie can have more than one star.

1. Which movies’ show times are longer than “I Know What You Did.” but shorter than “Wonton Soup”?

2. What are the full addresses of all movie theatres in California?

Hints: you need to use NVL() function. Please read Oracle document for its usage.

3. What are movie titles that start with letter ‘T’ and are released between 2000 and 2005?

4. How many theatres are in New York or Connecticut?

5. How many movie people are not actors?

6. Find all actors whose last name contains an ‘a’ in the second position or first name ends with an ‘a’.

7. Find all theatres whose names have the pattern of ‘name Theatre’ (e.g. ‘Worst Theatre’ where ‘Worst’ is the name), and extract the name (e.g. Worst).

Writerbay.net

Do you need help with this or a different assignment? We offer CONFIDENTIAL, ORIGINAL (Turnitin/LopesWrite/SafeAssign checks), and PRIVATE services using latest (within 5 years) peer-reviewed articles. Kindly click on ORDER NOW to receive an A++ paper from our masters- and PhD writers.

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper