Session Ready
Exercise

Determine the monthly income

Now that you know how to find the table that you need to answer a question and how to use SQL to answer that question let's practice these skills end-to-end.

How much does this business make per month?

First, you will need to use pg_catalog.pg_tables to find the possible tables and determine which tables & columns you need to answer that question. Second, you will leverage the tools you learned in the previous chapter to prepare the answer.

Instructions 1/2
undefined XP
  • 1
  • 2
  • Run the first section of code to list your tables.
  • Explore the tables to determine which you need to answer the question.
  • Once you've figured out which table to use, fill in the blank in this statement SELECT * FROM ___ LIMIT 10.