Create a new query named sum_quantity to retrieve the sum of the quantities displayed in the Orders table. Use sum1 as name for the calculated field.
Create a new query named product_count to retrieve the total number of records displayed in the Products table. Use mycount as name for the calculated field. (use the ID field to meet the needs of the query)
Create a new query named pelpro that will display the Surname, Name, Description fields (in the above order) from the r_orders query. Make sure the pelpro query displays unique records.