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 MS SQL Server

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

Instruction

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

Exercise

Select all information from the CompanyCarTrip table.