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

SQL Practice Set in MS SQL Server

Introduction
Exercises with artists, museums and their pieces of art
Exercises with the band members table
11. Bands' members and their leaders
Exercises with employees, salaries and benefits

Instruction

Okay! Let's get started.

Exercise

Show the Nickname of each band member (name the column Member) and the Nickname of their leader (name the column Leader) in the same row.

Stuck? Here's a hint!

Remember that you can rename tables in a JOIN query using aliases, like so:

SELECT C1.Model as Newer, C2.Model as Older
FROM Car C1
JOIN Car C2
  ON C1.Age < C2.Age

Here, we joined the Car table twice to list new and old models together. Note the use of table aliases in the query to distinguish between the two instances of table Car in the query.