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

JOINs in MS SQL Server

Challenge time

Instruction

Okay! Here comes the second set of the tables. First, we have the Car table.

Exercise

Select all data from the Car table. It contains the following columns:

  • Id the ID of a given car,
  • Model – the model of a given car,
  • Brand – the brand of a given car,
  • OriginalPrice – the original price of a brand-new model of a given car,
  • Mileage – the total mileage of a given car, and
  • ProdYear – the production year of a given car.