Please the previous question 1 to 3

4- Write SQL queries for the following: . Retrieve all the invoice ids and invoice_totals that are greater than the maximum invoice_total of vendor whose vendor id is 37 (Hint you could use a subquery here) Create a view that has the following information: a. Vendor's id b. Total dollar value of all invoice per vendor c. Number of invoices per vendor d. latest invoice_due_date per vendor (Hint you would want to use group by to create the view) Write a query against the view to find the vendor with more than 2 invoices