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

GROUP BY Extensions in SQL

Introduction
Quiz
2. Get to know the company_car_trip table
The End

Instruction

Before we start, let's get to know the table we'll be working with. It's named company_car_trip and it describes trips made by the company cars of an imaginary business. The table contains the following columns:

  • id – the ID of the trip.
  • year – the year of the trip.
  • month – the month of the trip.
  • day – the day of the trip.
  • country – the country in which the trip was taken.
  • car_size – the size of the car driven (either Small or Big).
  • trip_type – the type of trip (either BusinessTrip or ProductTransport).
  • distance – the distance driven, in km.
  • fuel_consumed – the amount of fuel consumed during the trip, in liters.

Exercise

Select all information from the company_car_trip table.