1. Learn
    2. /
  2. Courses
    3. /
  3. Database Design

Exercise

Querying the star schema

The novel genre hasn't been selling as well as your company predicted. To help remedy this, you've been tasked to run some analytics on the novel genre to find which areas the Sales team should target. To begin, you want to look at the total amount of sales made in each state from books in the novel genre.

Luckily, you've just finished setting up a data warehouse with the following star schema:

The tables from this schema have been loaded. Note that you should not use aliases in FROM and JOIN statements.

Instructions

100 XP
  • Select state from the appropriate table and the total sales_amount.
  • Complete the JOIN on book_id.
  • Complete the JOIN to connect the dim_store_star table
  • Conditionally select for books with the genre novel.
  • Group the results by state.