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

Recursive Queries in MS SQL Server

Introduction
Quiz
5. Exercise 1
Congratulations

Instruction

Good job! Let's start with our quiz.

Exercise

Find all recipes, but select only the Name, Rating, and CookTime for each recipe. Sort records by rating in descending order, with the names of equally-rated recipes in ascending alphabetical order.

Stuck? Here's a hint!

Sort data using ORDER BY. Look at SQL Basics in SQL Server course. Part 4: Aggregation and grouping to review the material about sorting records.