The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

code

Back to all questions

code

9 months ago
Vote Up Vote Down
0
Votes
1
Answer

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

1 Answer

365 Team 9 months ago
Vote Up Vote Down
0
Votes

Hi Luigi!

Congratulations on writing a challenging query!

Thanks for reaching out and sharing your query with the Community!

Best,
Martin

You must to answer this question.
×
Online Data Science Training
SAVE 60%