Query_practice

Query_practice - ACCESS DATABASE PRACTICE Unless...

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

View Full Document Right Arrow Icon
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.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/28/2011 for the course ACCT 307 taught by Professor Scrowley during the Spring '08 term at S.F. State.

Page1 / 4

Query_practice - ACCESS DATABASE PRACTICE Unless...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online