{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Query_practice

# Query_practice - ACCESS DATABASE PRACTICE Unless...

This preview shows pages 1–2. Sign up to view the full content.

ACCESS DATABASE PRACTICE Unless specifically noted, each query is independent of the others. Q1. List all action movies. Show only the movieID, title, genre, and cost fields. Q2. List all movies that begin with the letters “X” and “Y”. Show the titles and box office gross. Q3. List all comedies that begin with the letter “B” and all action movies that begin with the letter “S”. Q4. List all movies that were released in 2008. Include title, genre, box office, and year released. Q5. List all movies that were released before 1990. Include the same fields as Q4. Sort by year released, with the oldest movies listed first. Q6. List all movies that were released between 1965 and 2000. Include the same fields as Q4. Sort by year released, with the most recent movies listed first. Q7. Find the average cost of the movies in each genre. Q8. How many movies of each genre have made over \$150,000,000? Q9. What is the average box office gross for each genre? Use the standard number format with zero decimal places. Q10. How many action movies have made over \$200,000,000? Q11. Assume an average annual inflation rate of 2.0% since 1910. Calculate the inflation-adjusted box office gross for each movie. (HINT: You will have to manually re-create the future value formula in Access.) Show movie title, genre, year released, historical box office, and adjusted box office. Use standard number format with zero decimal places for the adjusted box office. Sort by adjusted box office, descending order. What is the highest-grossing movie, adjusted for inflation? Q12. Recalculate Q11 using a 2.3% annual inflation rate. Now what is the highest-grossing movie, adjusted for inflation? Q13. Create a query which concatenates the first name and last name of each customer. Include a space between the names. Include the customer’s phone number in the output.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}