CSC 436 - Assignment #2
PostgreSQL
Humungo Video Stores Queries

Queries:
  1. Find the names of all films that cost more than $10 million.
  2. Find the average salary paid on each film, sorted by the film title.
  3. Find the names and roles of all actors in the film "DOLORES CLAIBORNE".
  4. Find the names of all actors in films with Kevin Bacon.
  5. Display the number of items purchased by each shopper, sorted by shopper's last name.
  6. Which items (film title, format and price) that are being purchased cost more than $25?
  7. Show how much money each shopper has spent altogether. Sort the results by the total spent by each shopper.
  8. I want to buy every DVD starring JOHN TRAVOLTA. How much will this cost?
  9. What is the least expensive VHS made by PARAMOUNT?
  10. Find the director and studio that paid the highest salary for any actor.
  11. Find the names of all films that are not in any current shopping carts.
  12. What is the title, price (and format) of the film that has the highest budget?
  13. For each film that has both DVD and VHS formats, find the total number of items in inventory (DVDs plus VHSs).
  14. How many films has the lowest paid actress been in? (Use average salary over all films)
Also:
Create two of your own interesting queries, each using at least two relations.  Include the English description of the query as well as the SQL and the result.