Use Microsoft SQL Server Management Studio.

/************************************************************************* Do NOT use any subqueries in this section on aggregation. All columns in the output from the query must be named. Use AS when naming the columns. **************************************************************************/

--1. What five customers have the highest balances? Show all the columns in the results. (Pratt N/A)

--BEGIN STUDENT CODE use Premiere;

--END STUDENT CODE

--2. List the top twenty percent of customers based on highest balances. Show all the columns in the results. (Pratt N/A)

--BEGIN STUDENT CODE use Premiere;

--END STUDENT CODE

--3. List the top twenty percent of customers based on the highest credit limits amounts. You will have four rows of output, not two. Show all the columns in the results. (Pratt N/A)

--BEGIN STUDENT CODE

--END STUDENT CODE