My issue
I have already completed the query but I wanted to ask if there’s any other way by which we can find out the number of employees should be more than 3 except this code “having count(*)>3”
My code
/* Write a query to find out the average Payout across department which has more than 3 employees from the table employee.
The output table should have the name of the department and their respective average pay. */
select Department, avg(Payout) as 'avg_payout'
from employee
group by Department
having count(*)>3
Learning course: Learn SQL
Problem Link: CodeChef: Practical coding for everyone