linq to sql how to select data from two tables with groupby and orderby : SELECT        TOP (5) Sales.Product, Sales.Product_Price, COUNT(*) AS CNT, Products.Category, Products.IMG_URL, Products.Rate_Avg
FROM            Sales INNER JOIN
                         Products ON Sales.Product = Products.Product
GROUP BY Sales.Product, Sales.Product_Price, Products.Category, Products.IMG_URL, Products.Rate_Avg
HAVING        (COUNT(*) > 1)
ORDER BY CNT DESC