1)Write a query to determine the cost of the least expensive part in the part table?

1)Write a query to determine the cost of the least expensive part in the part table? Format the returned price in dollars and cents using the correct function. Your result set should have only one amount in it.2)Write a sub query that will list the part number, part description, and units on hand of all parts where the number of units on hand is greater than the average of units on hand for all parts.