Write a SELECT statement that returns six columns, based on the eqpTotalValue field in the EQUIPMENT table:

1 The eqpDescription should display in the first column

2 The original eqpTotalValue should display in the second column

3 Use the CAST function to return the eqpTotalValue in the third column as data type decimal with 2 digits to the right of the decimal point

4 Use the CAST function to return the eqpTotalValue in the fourth column as a varchar

5 Use the CONVERT function to return the eqpTotalValue in the fifth column as decimal with 2 digits to the right of the decimal point

6 Use CONVERT to return the eqpTotalValue in the sixth column as varchar, using style 1

7 Use a $ to display on the left of the value where possible (HINT: concatenation)

8 Use appropriate descriptive column alias names

9 The highest eqpTotalValue should display at the top of the result set