-
Notifications
You must be signed in to change notification settings - Fork 1
/
Hockey DB.sqbpro
11 lines (5 loc) · 3.11 KB
/
Hockey DB.sqbpro
1
2
3
4
5
6
<?xml version="1.0" encoding="UTF-8"?><sqlb_project><db path="C:/Users/Patrick/Documents/Coding/Python/Hockey Experiments/Hockey DB.db" readonly="0" foreign_keys="0" case_sensitive_like="0" temp_store="0" wal_autocheckpoint="0" synchronous="1"/><attached/><window><main_tabs open="structure browser pragmas query" current="0"/></window><tab_structure><column_width id="0" width="300"/><column_width id="1" width="0"/><column_width id="2" width="100"/><column_width id="3" width="1177"/><column_width id="4" width="0"/><expanded_item id="0" parent="1"/><expanded_item id="0" parent="0"/><expanded_item id="1" parent="1"/><expanded_item id="2" parent="1"/><expanded_item id="3" parent="1"/></tab_structure><tab_browse><current_table name="4,27:mainMarchThirdTwentyTwentyThree"/><default_encoding codec=""/><browse_table_settings><table schema="main" name="03_14_23" show_row_id="0" encoding="" plot_x_axis="" unlock_view_pk="_rowid_"><sort><column index="5" mode="0"/></sort><column_widths><column index="1" value="154"/><column index="2" value="123"/><column index="3" value="211"/><column index="4" value="149"/><column index="5" value="148"/></column_widths><filter_values/><conditional_formats/><row_id_formats/><display_formats><column index="5" value=""/></display_formats><hidden_columns/><plot_y_axes/><global_filter/></table><table schema="main" name="Lightning_vs_New Jersey Devils_03_14_2023" show_row_id="0" encoding="" plot_x_axis="" unlock_view_pk="_rowid_"><sort/><column_widths><column index="1" value="154"/><column index="2" value="123"/><column index="3" value="211"/><column index="4" value="149"/><column index="5" value="145"/></column_widths><filter_values/><conditional_formats/><row_id_formats/><display_formats/><hidden_columns/><plot_y_axes/><global_filter/></table><table schema="main" name="MarchThirdTwentyTwentyThree" show_row_id="0" encoding="" plot_x_axis="" unlock_view_pk="_rowid_"><sort/><column_widths><column index="1" value="154"/><column index="2" value="123"/><column index="3" value="211"/><column index="4" value="149"/><column index="5" value="148"/></column_widths><filter_values/><conditional_formats/><row_id_formats/><display_formats/><hidden_columns/><plot_y_axes/><global_filter/></table><table schema="main" name="player_stats_Blackhawks_vs_Boston Bruins_03_14_2023" show_row_id="0" encoding="" plot_x_axis="" unlock_view_pk="_rowid_"><sort/><column_widths><column index="1" value="154"/><column index="2" value="123"/><column index="3" value="211"/><column index="4" value="149"/><column index="5" value="148"/></column_widths><filter_values/><conditional_formats/><row_id_formats/><display_formats/><hidden_columns/><plot_y_axes/><global_filter/></table></browse_table_settings></tab_browse><tab_sql><sql name="SQL 1">SELECT Player AS P, ShotsorSaves AS S, ShotsorSavesAgainstOpponent AS O, ShotsorSavesatHome AS C, ShotsorSavesinMarch AS M
FROM MarchThirdTwentyTwentyThree;
SELECT P
-- (SELECT AVG(MyAverage) FROM (VALUES (ShotsorSaves),(ShotsorSavesAgainstOpponent),(ShotsorSavesatHome),(ShotsorSavesinMarch)) AS TblAverage(MyAverage))
FROM MarchThirdTwentyTwentyThree</sql><current_tab id="0"/></tab_sql></sqlb_project>