#3: Use your common sense on these. Show the SQL query AND the output. DO NOT pr

Question

#3: Use your common sense on these. Show the SQL query AND the output. DO NOT provide IDs in the final answer; all answers should be meaningful. Be careful; a movie can have more than one star. I strongly recommend that you look at the data you are querying first, and test your subqueries (if you need) before you incorporate them in a query h movies' show times are longer than " 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 NVLO 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 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 (eg. worst). 8

Explanation / Answer

Since the relations are not specified I ll be assuming them are modifying them on the go considering that movies is that one relation which stores everything.

1. select movie_name from movies where time>(select time from movies where name="I know what you did") and time<(select time from movies where Wontan Soup");

2. select address, city, state from movies where state="California";

3. select movie_name from movies where movie_name like "T%" and date>=2000-01-01 and date<=2005-12-31;

4. select count(*) from movies where state="New York" or state="Connecticut";

As per chegg guideleines we are only supposed to answer the first 4 parts.

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.