My issue
My code
/* Write a query to output the following
- Department and average payout on a single line
- Where total payout of the department is more than 40. */
SELECT Department,
Avg(Payout) as 'avg_payout'
FROM employee
GROUP BY Department
HAVING Sum(Payout) > 40;
Learning course: Learn SQL
Problem Link: CodeChef: Practical coding for everyone
Where Do I find the table this derives from?