4. (10 pts) Write a SELECT statement that returns four columns from the EQUIPMENT table: a. TotalValue, where TotalValue is the sum of the eqpTotalValue column b. AverageValue where AverageValue is the average of the eqpTotalValue column c. LowValue where LowValue is the lowest of the eqpTotalValue column d. HighValue where HighValue is the highest of the eqpTotalValue column e. Use appropriate column aliases INFO2411 Advanced Database \& SQL 1 of 2 5. (4 pts) Write a SELECT statement that returns two columns from the EQUIPMENT, eqpNo and eqpTotalValue. Return only three rows, corresponding to the top three total values. Use appropriate column alias names. 6. (5 pts) Write a SELECT statement that returns the empssn, emplast and the number of dependents for each employee with dependents. Sort the results so that the employee with the highest number of dependents is at the top. Use appropriate column alias names. 7. (2 pts) Modify the SELECT statement used in Step 6 to only show those employees with 3 or more dependents. 8. (5 pts) Write a SELECT statement that returns the number of employees that do not have any dependents. Use an appropriate column alias name. The result set should have only 1 column and 1 row