--- title: Top College Scorers sidebar_link: true sidebar_position: 1 --- ```sql leagues select distinct league from cbb.points order by league ``` ```sql divisions select distinct division from cbb.points where (division > 0) order by division ``` ```sql genders select distinct gender from cbb.points order by gender ``` ```sql points select player, end_yr, league, points from cbb.points ``` ```sql points_3000 select concat(player, ', ', cast(end_yr as int)) as player_yr, league, points from cbb.points where (points >= 3000) and (league like '${inputs.selected_league.value}') and (division like '${inputs.selected_division.value}%') and (gender like '${inputs.selected_gender.value}') and (end_yr BETWEEN ${inputs.selected_years.value}) order by points desc ``` ```sql points_3000_avg_yr select concat(player, ', ', cast(end_yr as int)) as player_yr, cast(points/(end_yr-start_yr+1) as int) as pts_yr, league, points from cbb.points where (end_yr is not null) and (start_yr is not null) and (league like '${inputs.selected_league.value}') and (division like '${inputs.selected_division.value}%') and (gender like '${inputs.selected_gender.value}') and (end_yr BETWEEN ${inputs.selected_years.value}) order by pts_yr desc limit 25 ``` ```sql pts_avg_25 select concat(player, ', ', cast(end_yr as int)) as player_yr, league, pts_avg from cbb.points where (pts_avg >= 25) and (league like '${inputs.selected_league.value}') and (division like '${inputs.selected_division.value}%') and (gender like '${inputs.selected_gender.value}') and (end_yr BETWEEN ${inputs.selected_years.value}) order by pts_avg desc ``` ```sql pts_notes select concat(player, ', ', cast(end_yr as int)) as player_yr, notes from cbb.points where ((notes is not null) and (notes != '')) and ((points >= 3000) or (pts_avg >= 25)) order by points desc ``` ### Career Total of 3000+ Points

{#each pts_notes as n} {#if n.notes.indexOf('pts',0) > 0}

{n.player_yr}: {n.notes}

{/if} {/each}

### Average Points per Year ### Career Average of 25+ PPG

3PT Scoring

Most 3PT Field Goals Made

Percentage of Points From 3PT Field Goals

What If? Revised Scoring Totals Without a 3PT Line