My issue
Not able to solve the problem
My code
/* Write a query to output the following
- Type of pizza, Average time required to cook, Average time required to pack, Average delay time - grouped by the type of pizza
- Rename the Average time required to cook column as 'Average_cook'
Rename the Average time required to pack column as 'Average_pack'
Rename the Average delay time as ''Average_delay'
- Round the average time to 1 digit after the decimal */
SELECT
type of pizza
ROUND(AVG(cook_time), 1) AS Average_cook,
ROUND(AVG(pack_time), 1) AS Average_pack,
ROUND(AVG(delay_time), 1) AS Average_delay
FROM
Orders
GROUP BY
type of pizza;
Learning course: Learn Data Analytics using SQL and Python
Problem Link: Practice Problem in - CodeChef