I'm trying to create a mysql query to view the table where the search query is stored. This query attempts to get all rows matching the following criteria:

• >= To a date
• Return only rows where the search query appears 3 or more times
• Also only returns rows where 2 or more users have used the search query

This query doesn't work but should outline what I'm trying to do:

SELECT 
  * 
FROM 
  `analytics` 
WHERE 
  `date` >= '2021-01-01' 
GROUP BY 
  `query` 
HAVING 
  COUNT(*) >= 3 
  AND 
GROUP BY 
  `user` 
HAVING 
  COUNT(*) >= 2 
ORDER BY 
  id DESC;

Sample data

Example SQL

SELECT 
  * 
FROM 
  analytics 
WHERE 
  date >= '2021-01-01' 
GROUP BY 
  query 
HAVING 
  COUNT(*) >= 3 
  AND 
GROUP BY 
  user 
HAVING 
  COUNT(*) >= 2 
ORDER BY 
  id DESC;

Using the values ​​set in the query above, a single row should be returned for the query "What is a dogs", all other columns are unimportant.

I know you can GROUP BY separate columns with commas, but I can't seem to figure out how to set a different value for each column.