All-Rounders Performance

Write a SQL query to find all-rounders (runs > 0 AND wickets > 0 in any match).

Expected Columns

• player_name
• total_runs
• total_wickets

Example Output

| player_name | total_runs | total_wickets | |-------------|------------|---------------| | Ravindra Jadeja | 38 | 2 | | Andre Russell | 65 | 1 | | Sunil Narine | 28 | 4 | | Axar Patel | 22 | 3 |