End of Summer - hours only!Up to 80% off on all courses and bundles.-Close
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 group_level day hour
3 Mary Sue French A1 monday 13:00:00
3 Mary Sue French A1 friday 13:00:00