🔎 Ask
Ask a question
Type it the way you would say it. The words are read against this site's own vocabulary — age groups, competitions, states, roles, weekends and statistics — and turned into one query. Whatever is not understood is listed rather than quietly dropped, and the SQL is shown.
Understood as
Players
Bowling average under 20
VIC
Bowlers
sorted by rating ↓
More than 10,000 players
showing the first 20| Player | Rating↓ | ||||
|---|---|---|---|---|---|
|
Annabelle Glossop
⭐
20 · U18 VIC · First-Change Bowler
|
20 U18 VIC | First-Change Bowler | Rating 74 | 1080 | 93 |
|
Ira Aery
⭐
20 · U19 VIC · Opening Bowler
|
20 U19 VIC | Opening Bowler | Rating 62 | 1324 | 160 |
|
Kim Garth
⭐
30 · VIC · Opening Bowler
|
30 VIC | Opening Bowler | Rating 59 | 2851 | 202 |
|
Thomas Paddington
⭐
19 · U19 VIC · Opening Bowler
|
19 U19 VIC | Opening Bowler | Rating 59 | 329 | 172 |
|
Alice Capsey
⭐
VIC · Second-Change Bowler
|
— VIC | Second-Change Bowler | Rating 54 | 456 | 30 |
|
Akshay Ramkumar
⭐
17 · U17 VIC · First-Change Bowler
|
17 U17 VIC | First-Change Bowler | Rating 49 | 1557 | 152 |
|
Logan Collins
⭐
16 · U15 VIC · Opening Bowler
|
16 U15 VIC | Opening Bowler | Rating 49 | 1468 | 176 |
|
Sarah Burton
⭐
19 · U19 VIC · Second-Change Bowler
|
19 U19 VIC | Second-Change Bowler | Rating 49 | 2291 | 223 |
|
Erika Quinn
⭐
27 · U19 VIC · Second-Change Bowler
|
27 U19 VIC | Second-Change Bowler | Rating 48 | 314 | 342 |
|
Jess Field
⭐
25 · U19 VIC · First-Change Bowler
|
25 U19 VIC | First-Change Bowler | Rating 48 | 1915 | 154 |
|
Katia Jomini
⭐
VIC · First-Change Bowler
|
— VIC | First-Change Bowler | Rating 48 | 120 | 58 |
|
Lucy Page
⭐
22 · U19 VIC · First-Change Bowler
|
22 U19 VIC | First-Change Bowler | Rating 48 | 3017 | 193 |
|
Tahlia Simpson
⭐
27 · U16 VIC · First-Change Bowler
|
27 U16 VIC | First-Change Bowler | Rating 46 | 1716 | 166 |
|
Zane Attard
⭐
19 · U19 VIC · First-Change Bowler
|
19 U19 VIC | First-Change Bowler | Rating 46 | 6301 | 367 |
|
Kaevish Bhasin
⭐
15 · U12 VIC · Second-Change Bowler
|
15 U12 VIC | Second-Change Bowler | Rating 44 | 2777 | 163 |
|
Kepler Lukies
⭐
19 · U19 VIC · First-Change Bowler
|
19 U19 VIC | First-Change Bowler | Rating 43 | 2821 | 270 |
|
Luke McCann
⭐
17 · U17 VIC · Opening Bowler
|
17 U17 VIC | Opening Bowler | Rating 43 | 644 | 113 |
|
Ananya Mahajan
⭐
16 · U16 VIC · Opening Bowler
|
16 U16 VIC | Opening Bowler | Rating 41 | 1070 | 87 |
|
Brooklyn Diwell
⭐
20 · U19 VIC · First-Change Bowler
|
20 U19 VIC | First-Change Bowler | Rating 41 | 75 | 58 |
|
Georgia Naughton
⭐
17 · U16 VIC · Second-Change Bowler
|
17 U16 VIC | Second-Change Bowler | Rating 41 | 1361 | 179 |
Show the SQL
select "p"."id", "p"."name", "p"."state", "p"."age_group", "p"."overall_rating", "p"."is_div1_rep", "p"."is_international", "p"."date_of_birth", "p"."born_on_or_after", "pr"."role", "pr"."rating", "pr"."national_rank", "st"."runs", "st"."bat_avg", "st"."sr", "st"."wkts", "st"."bowl_avg", "st"."econ" from "players" as "p" left join "player_ranks" as "pr" on "pr"."player_id" = "p"."id" left join "player_rankings" as "st" on "st"."player_id" = "p"."id" and "st"."scope" = 'all' where "p"."name"::text not like '%********%' and "p"."name"::text not like 'Unknown Player_%' and not exists (select * from "player_merge_members" as "pmm" inner join "player_merges" as "pm" on "pm"."id" = "pmm"."merge_id" where "pmm"."player_id" = "p"."id" and "pmm"."player_id" != "pm"."master_id") and "st"."bowl_avg" <= 20 and "p"."state" = 'VIC' and "pr"."squad_slot" = 'bowl' order by coalesce(p.overall_rating, 0) desc, "p"."name" asc limit 20 offset 0