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

Window Functions in MS SQL Server

Introduction
Selecting n-th row
Summary
23. The Application table

Instruction

You know the Game and Purchase tables very well now, so let's change to a new table for our quiz. The game studio decided to start making applications as well. Let's see what information we can find in the Application table.

Exercise

Select all information in the Application table.

Each application has an Id and a Name, is intended for a specific Platform, and has a certain Type. Each app also has an AverageRating from users, a number of Downloads, and the overall Income it has generated.