Movies Database - Part 3 (Queries)

Today, you will be creating a query based on the movies table that you created.

• Create a query using the wizard based on the movies table
• Click on Queries on the left hand side of your screen
• Then, click on Create Query using Wizard.
• Select the Movies table and select ALL fields EXCEPT Director to be included.
• Click Next
• Sort by Movie Title in DESCENDING order
• Then, click on MATCH ALL OF THE FOLLOWING
• Choose Total Gross as the Field, Is Greater Than for the condition, and type in 100,000,000 for the value. (This will filter movies that only made more than $100 Million)
• Click Next
• Choose Detailed Query
• Leave the aliases as is
• Name the Query "Income Query, then select modify query
• Click Finish

You have now created a query!! Save as Income Query and close.