PLEASE HELP ASAP! WILL MARK BRAINLIEST IF THE ANSWER IS CORRECT! I NEED HELP WITH THE 3RD ONE! Using the premiere database create the following SQL queries:
1.Display all information from the customer table for all customers that have a balance that is greater than the average balance.
SELECT * FROM customer WHERE customer. balance > (SELECT avg(customer. balance) FROM customer)
2.Display all information from the rep table for all representatives that have a rate which is equal to the minimum rate for representatives.
SELECT * FROM `rep` WHERE `rate` = (SELECT MIN(rate) from rep)
3.Display each unique description and price (no duplicates) for all parts that have a quoted price that is greater than the average quoted price for all parts ordered.
???