sql group by count code example

Example 1: sql count group by

SELECT gender, COUNT(*) FROM people GROUP BY gender;

Example 2: sql groub by count

SELECT COUNT(Id), Country 
  FROM Customer
 GROUP BY Country

Example 3: sql avg and group by

SELECT
  AVG(depdelay),
  origin
FROM flight_delays
WHERE distance > 2000
GROUP BY origin;

Example 4: group by sql

# Say you have a table called SALARIES that contains a 
# few duplicate NAME entries...
+----+-------------+--------+
| ID |    NAME     | SALARY |
+----+-------------+--------+
| 1	 |     Bob     |  500   |
| 2  |    Alice    |  500   |
| 3  |    Alice    |  200   |
| 4  |    Frank    |  700   |
| 5  |    Percy    |  100   |
| 6  |    Percy    |  800   |
| 7  |   Cyrille   |  400   |
+----+-------------+--------+

# We can obtain the total salaries of each person
# by using GROUP BY in the following query...
SELECT NAME, SALARY FROM SALARIES GROUP BY NAME;

# Which will output the following...
+------------+--------+
|   Alice    |  700   |
|    Bob     |  500   |
|  Cyrille   |  400   |
|   Frank    |  700   |
|   Percy    |  900   |
+------------+--------+

Example 5: select query group by name

SELECT `gender` FROM `members` GROUP BY `gender`;