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 makes 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

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.

Take Hint (-15 XP)