The following exercises are based on the following three relations: SALESPERSON (SalesPersonID, Name, Age, Salary) ORDER (Number, CustomerID, SalespersonID, Amount, OrderYear) CUSTOMER (CustomerID, Name, City, Country, Industry Type) Write down the SQL statements for retrieving information i. Show the names and salaries of all salespeople under thirty years old and earning more than $30000 sorted by highest pay first. ii. Show the names and salary of all salespeople who have order(s) from customer ABC CONSTRUCTION. Records to be sorted by descending salary (and ascending names) iii. Compute the average salary and median age of all salesperson. iv. Show the name and age of the oldest salesperson. (Hint: use subquery)