code
today I ran this code.....proud of myself! hahaha xD
SELECT
emp_no, COUNT(salary)
FROM
employees.salaries
WHERE
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) Good everybody
emp_no, COUNT(salary)
FROM
employees.salaries
WHERE
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) Good everybody
1 answers ( 0 marked as helpful)
Hi Luigi!
Congratulations on writing a challenging query!
Thanks for reaching out and sharing your query with the Community!
Best,
Martin