How to get the top occurrence of rows to show SSMS 19

GarthVader , the more correct query would be

SELECT TOP 1 SUB.Product, SUB.Occurrences
   (SELECT Product, COUNT(*) AS Occurrences
    FROM Sales
    WHERE Product IS NOT NULL
    GROUP BY Product) AS SUB
ORDER BY SUB.Occurrences DESC;

Or use ROW_NUMBER (Transact-SQL) - SQL Server | Microsoft Learn