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.
Bu egzersiz
Applying SQL to Real-World Problems
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- List all tables in the public schema
SELECT *
FROM pg_catalog.pg_tables
WHERE schemaname = 'public';
-- Explore the tables and fill in the correct one
SELECT *
FROM ___
LIMIT 10;