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

Good job! How about this one? Afterwards, we'll change tables.

Exercise

For all groups taught in the La Lingua school, show the following information:

  • the ID of a given group,
  • the name of the lecturer who teaches that group,
  • the language that the group learns,
  • the level of the group, and
  • the days and hours when the group has lectures.

However, show this information only for those groups that have both their lectures at the same hour and whose tuition is greater than 800 dollars.

Here's what the result should look like:

Id Name Language GroupLevel Day Hour
3 Mary Sue French A1 monday 13:00:00
3 Mary Sue French A1 friday 13:00:00