There are a total of 500 orders with one item per order, 1000 orders with two items per order, and 800 orders with three items per order."Example Output:mean2.7ExplanationLet's calculate the arithmetic average:Total items = (1*500) + (2*1000) + (3*800) + (4*1000) = 8900Total orders = 500 + 1000 + 800 + 1000 = 3300Mean = 8900 / 3300 = 2.7The dataset you are querying against may have different input & output - this is just an example!Gimme a Hint12function round(double precision, integer) does not exist (LINE: 1)PostgreSQL 14Run CodeSubmitErrorfunction round(double precision, integer) does not exist (LINE: 1)

The average of 100 items was found to be 30. If at the time of calculation, two items were wrongly taken as 32 and 12 instead of 23 and 11, then the correct average is?Options29.829.929.529

The average of 9 items is 79. If one new item whose value is 59 is also included in the series, find average of all the 10 items.A77B80C81D83

29. What is the result of the following SQL Query? SELECT COUNT(*), AVG(amount) FROM Orders WHERE amount > 200; Number of orders with amount > 200 and the average amount of these orders.Total number of orders and the average amount of all orders.Number of customers with orders > 200 and the average order amount per customer.Total number of orders > 200 and the average number of orders.

The mean of 200 values of a data was 50. It was later found that two values were wrongly readas 92 and 8 instead of 192 and 88 respectively. The correct mean is:

SELECT round(sum(item_count*order_occurrences)/sum(order_occurrences),1) as meanFROM items_per_order