Oracle SQL

Are you pressed for time and haven’t started working on your assignment yet? Would you like to buy an assignment? Use our custom writing services for better grades. Even if your deadline is approaching fast, our writers can handle your task right when you need it. Our writers will complete your order from scratch and make sure it’s completely unique.


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? Even when your task is complicated and the deadline is in less than 2 days, you still have every chance to get a good grade for it. How? By completing the order form, you will get the finest custom-written assignment at an affordable price. We also deliver a number of services for free (e.g., revisions, editing, checking the text for authenticity). Use our paper writing service to receive effective help with your homework.


Order a Similar Paper Order a Different Paper