I used this query to get particular result from a Microsoft SQL Server table, but now I need to convert this query into MySQL query. I don't know how to do that.
SELECT TOP 3 COUNT(Item1) AS ITEM_COUNT,Item1
WHERE [Type] = 'Adidas' and [Age]='25'
GROUP BY Item1
ORDER BY ITEM_COUNT DESC
SELECT COUNT(Item1) AS ITEM_COUNT,Item1 FROM Suggetion_DB WHERE Type = 'Adidas' and Age='25' GROUP BY Item1 ORDER BY ITEM_COUNT DESC limit 3