Introduction
3. Table daily_sales
Nested CTEs
Summary

Instruction

Excellent, let's move on.

Exercise

Select all information from the daily_sales table.

A single row represents daily results of a salesman. There you will find the following columns:

• day - day to which the results apply,
• salesman_id - identifier of a salesman,
• items_sold - number of items sold by salesman on a given day,
• amount_earned - amount of money salesman acquired for those items,
• distance - distance that salesman drove on a given day,
• customers - number of customers salesman had on a given day.