Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
2. The Salesman table
Nested CTEs


First things first, though. Let's get to know today's data model. We're going to analyze the data of a company that sells small items on a door-to-door basis.


Select all the information from the Salesman table.

Each salesperson has a unique ID, a first and last name, and an ID for the city where he or she operates.