Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
2. Get to know the company_car_trip table
The End


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.


Select all information from the company_car_trip table.