today I ran this code…..proud of myself! hahaha xD
from_date > ‘1999-01-01’
GROUP BY emp_no
HAVING COUNT(salary > 80000)
ORDER BY emp_no;
The filter was: give me back the number of times any employs earned more than 80000 after the first of January 1999.
I had some difficulties how to realize HAVING COUNT(salary > 80000)
Congratulations on writing a challenging query!
Thanks for reaching out and sharing your query with the Community!