Skip to content
/ CompanionScripts Public

Exploratory SQL scripts for understanding franchise data for SMB Companion

0 stars 0 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

tbrittain/CompanionScripts

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

35 Commits
.idea
.idea
 
 
30_30_seasons.sql
30_30_seasons.sql
 
 
README.md
README.md
 
 
average_ops_per_season.sql
average_ops_per_season.sql
 
 
batter_output_rankings.sql
batter_output_rankings.sql
 
 
best_contact_pitchers.sql
best_contact_pitchers.sql
 
 
career_k_per_9_leaders.sql
career_k_per_9_leaders.sql
 
 
division_relative_difficulty.sql
division_relative_difficulty.sql
 
 
game_score_frequency.sql
game_score_frequency.sql
 
 
home_field_advantage.sql
home_field_advantage.sql
 
 
most_common_team_to_team_transactions.sql
most_common_team_to_team_transactions.sql
 
 
most_hits_lowest_hr_seasons.sql
most_hits_lowest_hr_seasons.sql
 
 
most_hr_fewest_hits_seasons.sql
most_hr_fewest_hits_seasons.sql
 
 
most_improved_players_year_to_year.sql
most_improved_players_year_to_year.sql
 
 
most_pitcher_wins_on_worst_teams.sql
most_pitcher_wins_on_worst_teams.sql
 
 
player_most_championship_wins.sql
player_most_championship_wins.sql
 
 
player_number_of_teams.sql
player_number_of_teams.sql
 
 
playoff_outcomes_by_seed.sql
playoff_outcomes_by_seed.sql
 
 
position_player_potential.sql
position_player_potential.sql
 
 
position_players_pitching.sql
position_players_pitching.sql
 
 
season_avg_ops_era.sql
season_avg_ops_era.sql
 
 
season_award_winners.sql
season_award_winners.sql
 
 
team_dynasties.sql
team_dynasties.sql
 
 
top_awardees.sql
top_awardees.sql
 
 
top_batters_last_3_seasons.sql
top_batters_last_3_seasons.sql
 
 
top_innings_pitched.sql
top_innings_pitched.sql
 
 
top_team_seasons_all_time.sql
top_team_seasons_all_time.sql
 
 
trait_effectiveness_pitching_reg_season.sql
trait_effectiveness_pitching_reg_season.sql
 
 
trait_effectiveness_reg_season.sql
trait_effectiveness_reg_season.sql
 
 

Repository files navigation

Companion Scripts

SQL scripts for exploring SMB Explorer Companion data

This repository contains SQL scripts for use with the application database for SMB Explorer Companion. Some of these may represent features that I want to add to the app, while others are just for exploring the data.

The majority of these queries were designed to work with a single franchise within the app. If you have multiple, you may need to add an additional filter based on the Franchise.Id.

About

Exploratory SQL scripts for understanding franchise data for SMB Companion

Resources

Readme
Activity

Stars

0 stars

Watchers

1 watching

Forks

0 forks
Report repository