Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
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.