title: Cannot use window function 'count' in having statement
body: <p>I'm new to MYSQL, and I'm trying to validate the number of data which have the same name from 2 column that occurs more than one time, which I already try to use 'having' statement in this case and it throws me an error like this
  <code>Error Code: 3593. You cannot use the window function 'count' in this context.'</code>
  below I include an image of what I'm trying to do 
  <a href="https://i.stack.imgur.com/VCOKn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VCOKn.png" alt="mysql workbench screenshot"></a></p>
  
  <p>you can see there a column named "number_of_same_year" represent the "COUNT OVER PARTITION" output, which has numbers that logically could be validated. I only want to show where the numbers are above 1 (which means occur more than one time)</p>
  
  <p>ps: I'm using MySQL in Windows 10</p>