View the step-by-step solution to:

Question

This question was created from 02p_sql_dml.pdf https://www.coursehero.com/file/34093665/02p-sql-dmlpdf/

34093665-358208.jpeg

What are the answers of these questions ?

34093665-358208.jpeg

Write and execute SQL queries
1. Using subquery, list details of staff who live in Alberta.
2. Using subquery, list details of actors who starred in film 'Academy Dinosaur'.
3. Using subquery, list details of staff who issued a rental on "2005-05-24".
hint: where rental date::date = date '2005-05-24' ;
4. List the title and language of all films.
5. List the title and category of all films.
6. Give the number of films in each category, ordered by category name.
7. Give the number of films for each actor, ordered by actor lastname and firstname.
8. For each city, list the number of stores. Display only those cities with at least one store.
9. List details of actors who played in more than ten films
10. Give the number of films rent by each customer.
11. List details of customers who rent the maximum number of films.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes