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 in PostgreSQL

Introduction
3. Daily_sales table
Summary

Instruction

Excellent. Let's move on.

Exercise

Select all information from the daily_sales table.

A single row represents a salesperson's daily results. In it you will find the following columns:

  • day – The day to which the results apply.
  • salesman_id – The salesperson's ID.
  • items_sold – The number of items sold by that person on that day.
  • amount_earned – The amount of money earned by these sales.
  • distance – The distance that person drove on that day.
  • customers – The number of customers on that day.