Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Recursive Queries

Introduction
3. Table daily_sales
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.