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


Before we start, let's get to know the table we'll be working with. It's named CompanyCarTrip 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
  • CarSize – The size of the car driven (either Small or Big)
  • TripType – The type of trip (either BusinessTrip or ProductTransport)
  • Distance – The distance driven, in km
  • FuelConsumed – The amount of fuel consumed during the trip, in liters


Select all information from the CompanyCarTrip table.