this is my assigment for data base can you solve it and show the out put and code step by step?

Lab Exercise - Use the online database provided by Live SQL in Find option. - To take an overview about any schema select Find option in live sql, then to access a table in your queries from other schema write shcema name before table name schema_abbreviation.table_name - For each query screenshot the SQL code and the result table. - Arrange everything in 1 file by the query number. - Upload your work to Blackboard as a PDF file. A. Work on the "Products" table from CO schema and apply the queries mentioned below. 1. Display the average price of products (name the result column as AVG_Price). 2. Display the most expensive product price (name the result column as Max_price). B. Work on the "CUSTOMER_ORDER_PRODUCTS" table from CO schema and apply the queries mentioned below. 1. Find the sum of order_total (name the result column as Total) for each customer. You must display customer_id column as shown. 2. Find the total number of different status of orders (cancelled, complete or refunded) using one sql statement. Hint: use group by. 3. Display total number of customers who only cancelled their orders. Hint: use distinct keyword because count function includes duplicates