All Problems
30

Players by Role

EasyCOUNTGROUP BY

Problem Description

Write a SQL query to count how many players are in each role (Batsman, Bowler, etc.).

Example Output

| role | player_count | |------|--------------| | Batsman | 4 | | Bowler | 2 | | All-rounder | 4 | | Wicketkeeper | 2 |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints
//#30 Players by Role
Easy

Loading schema...

Loading editor...

No results yet

Run a query to see results