Take Control: Q&A Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

Questions and Answers

Queries ask questions:“Who bought what?” Think of all those records in the tables.

 

In the Front Row Video database, your query could ask, “How many of these movies are 1-day rentals? How many are 3-day rentals?"

 

Video rental prices are usually based on the year that a movie was released. There is a premium price for new releases. Older movies can be rented for much less. Let’s find out which movies are new releases and which ones are older.