1. Learn
    2. /
  2. Courses
    3. /
  3. Applying SQL to Real-World Problems

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.