Collecting And Analyzing Halo Stats - With Azure, SQLite, Python, And GitHub

CREATE TABLE MatchStats ( ResponseBody TEXT , MatchId Text GENERATED ALWAYS AS ( json_extract ( ResponseBody , '$.MatchId' )) VIRTUAL , MatchInfo Text GENERATED ALWAYS AS ( json_extract ( ResponseBody , '$.MatchInfo' )) VIRTUAL , Teams Text GENERATED ALWAYS AS ( json_extract ( ResponseBody , '$.Teams' )) VIRTUAL , Players Text GENERATED ALWAYS AS ( json_extract ( ResponseBody , '$.Players' )) VIRTUAL ); CREATE TABLE PlayerMatchStats ( ResponseBody TEXT , MatchId TEXT , PlayerStats Text GENERATED ALWAYS AS ( json_extract ( ResponseBody , '$.Value' )) VIRTUAL ) CREATE TABLE PlayerRankSnapshots ( ResponseBody TEXT , PlaylistId TEXT , SnapshotTimestamp DATETIME , Snapshot Text GENERATED ALWAYS AS ( json_extract ( ResponseBody , '$.Value' )) VIRTUAL ) CREATE TABLE ServiceRecordSnapshots (…