sql group by count

Today, We want to share with you sql group by count.In this post we will show you sql count groups by multiple columns, hear for sql group by count(distinct) we will give you demo and example for implement.In this post, we will learn about sql groups by multiple columns with an example.

SQL GROUP BY, COUNT – with Examples

In this tutorial we learn to all about sql group by count Examples like as a COUNT, ORDER BY, ASC, DESC, GROUPBY or many more.


Also Read: Group by and Having Clause in SQL

Read Also:  Laravel Multiple Authentication Example

SQL GROUP BY Examples

SELECT COUNT(MemberID), Districts
FROM Members
GROUP BY Districts;

JOIN Example

SELECT Merchants.MerchantName, COUNT(Requets.OrderID) AS NumberOfRequets FROM Requets
LEFT JOIN Merchants ON Requets.MerchantID = Merchants.MerchantID
GROUP BY MerchantName;

SQL GROUP BY Clause

SELECT COUNT(Id), Districts 
  FROM Member
 GROUP BY Districts
 ORDER BY COUNT(Id) DESC

COUNT() with GROUP by

SELECT office, COUNT(*) 
FROM agents 
GROUP BY office;

SQL COUNT( ) with group by and order by

SELECT office, COUNT(*) 
FROM agents 
GROUP BY office 
ORDER BY 2 ;

SQL COUNT( ) group by and order by in descending

SELECT office, COUNT(*) 
FROM agents 
GROUP BY office 
ORDER BY 2 DESC;

Aggregations (COUNT, SUM, AVG)

SELECT
  location,
  COUNT(*) AS number_of_vendors
FROM vendors
GROUP BY location;

COUNT, ORDER BY, ASC, DESC, GROUP BY

SELECT country,
 COUNT(id) 
FROM user
GROUP BY  country
ORDER BY COUNT(id) DESC ;

SELECT country,
 COUNT(id) 
FROM user
GROUP BY  country
ORDER BY COUNT(id);

I hope you get an idea about sql groups by count.
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.