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

Great! We have lecturers. Thus, we also need to have student groups!

Exercise

Select all data from the StudentGroup table. It has five columns:

  • Id – the id of a given group,
  • PersonNo – the number of people in a given group,
  • Language – the language a given group learns, and
  • GroupLevel – the level of a given group,
  • LecturerId – the id of the lecturer who teaches a given group.