today I ran this code.....proud of myself! hahaha xD SELECT emp_no, COUNT(salary)FROMemployees.salariesWHEREfrom_date > '1999-01-01'GROUP BY emp_noHAVING 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) Good everybody

Hi Luigi! Congratulations on writing a challenging query! Thanks for reaching out and sharing your query with the Community! Best, Martin

Follow this topic

Last answered:

14 Mar 2020

Posted on:

11 Mar 2020

code

1 answers ( 0 marked as helpful)

Posted on:

14 Mar 2020