Grokking the Forward Deployed Engineer Interview
Vote

0% completed

​

SQL for Customer Data

"Did our clinics have more no-shows in the last 30 days than in the 30 days before? Which ones, and by how much?"

The operations manager of three physical therapy clinics sent this question. The answer is in the clinics' appointment database, which has four tables and about 90,000 rows. One SQL query answers it, but only if it counts the right rows.

Reading the Schema First

A schema is the list of tables in a database, with the columns of each table and the keys that connect them. Before writing a query, state in one sentence what one row of each table means

.....

.....

.....

Like the course? Get enrolled and start learning!

Reading Progress

0%


Vote for new content