SELECT Username, COUNT(Posts) FROM MyTable GROUP BY Username ORDER BY COUNT(Posts)
SELECT value1, value2, COUNT(value1) AS val FROM table_name GROUP by value1 , value2 HAVING val > 0 ORDER BY value2 DESC
SELECT year, SUM(profit) FROM sales GROUP BY year;
group by id order by name desc
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)