Case 1-2: Understanding the More Movies Database In this chapter, you saw the ERD and steps for creating the More Movies database, which is used for the second case project in every chapter. In this project, you perform several queries on the data to become familiar with it and to verify the content. Perform the queries listed in Table 1-3 and compare them with Figures 1-26 to 1-28 to verify your results.

Chapter 1 TABLE 1-3 Query tasks for the More Movies database What to Query List the ID, title, category ID, and category name for every movie in the 30 Results Figure Figure 1-26 Figure 1-27 Query # database. What five categories are used for movies List the member ID, last name, and suspension code for every member. Are any members suspended at this point? List the member last name, rental checkout date, and movie title for all Fiure 1-28 rentals. What checkout data applies to all recorded rentals? SHECT .oLe id. .ovse title, aie eat id, at-ote cstegoET Query Resut Rows Fetched: 12 m Osecond SeLF The good, the bad and the ugly Duck Soup Waking Ned Devine 4 Comedy 11 Deep Blue Sea Eement FIGURE 1-26 Results for Query 1