overv4 | michaelglass

Updated 2022-08-25

with overtime as ( select parse_json

[

{"new_game": "Nottingham Forest VS West Ham United - Soccer", "number_of_user": 17, "paid_amount": 6402.344782211, "days": "2022-08-16"},

{"new_game": "Salernitana VS AS Roma - Soccer", "number_of_user": 7, "paid_amount": 5944.481749747, "days": "2022-08-15"},

{"new_game": "Chelsea VS Tottenham Hotspur - Soccer", "number_of_user": 31, "paid_amount": 5653.693794437199, "days": "2022-08-15"},

{"new_game": "Buffalo Bills VS Indianapolis Colts - Football", "number_of_user": 6, "paid_amount": 11056.183121952, "days": "2022-08-14"},

{"new_game": "Leon Edwards VS Kamaru Usman - MMA", "number_of_user": 18, "paid_amount": 14114.635963593002, "days": "2022-08-15"},

{"new_game": "Boston Red Sox VS New York Yankees - Baseball", "number_of_user": 12, "paid_amount": 21571.061359724, "days": "2022-08-11"},

{"new_game": "Cincinnati Reds VS Chicago Cubs - Baseball", "number_of_user": 23, "paid_amount": 15593.5491098908, "days": "2022-08-12"},

{"new_game": "Philadelphia Phillies VS Miami Marlins - Baseball", "number_of_user": 12, "paid_amount": 12808.370916370599, "days": "2022-08-08"},

{"new_game": "Los Angeles Angels VS Minnesota Twins - Baseball", "number_of_user": 9, "paid_amount": 6051.012261177399, "days": "2022-08-14"},

{"new_game": "Colorado Rockies VS St. Louis Cardinals - Baseball", "number_of_user": 14, "paid_amount": 5594.117083797899, "days": "2022-08-11"},

{"new_game": "Indianapolis Colts VS Buffalo Bills - Football", "number_of_user": 6, "paid_amount": 11056.183121952, "days": "2022-08-14"},

{"new_game": "Kamaru Usman VS Leon Edwards - MMA", "number_of_user": 20, "paid_amount": 14114.635963593002, "days": "2022-08-01"},

{"new_game": "New York Yankees VS Boston Red Sox - Baseball", "number_of_user": 13, "paid_amount": 21571.061359724, "days": "2022-08-09"},

{"new_game": "Chicago Cubs VS Cincinnati Reds - Baseball", "number_of_user": 11, "paid_amount": 15593.5491098908, "days": "2022-08-10"},

{"new_game": "Salernitana VS Chelsea - Soccer", "number_of_user": 7, "paid_amount": 5944.481749747, "days": "2022-08-13"},

{"new_game": "Leon VS Usman - MMA", "number_of_user": 18, "paid_amount": 14114.635963593002, "days": "2022-08-03"},

{"new_game": "AS Roma VS Tottenham Hotspur - Soccer", "number_of_user": 31, "paid_amount": 5653.693794437199, "days": "2022-08-06"},

{"new_game": "Cincinnati Reds VS Philadelphia Phillies - Baseball", "number_of_user": 23, "paid_amount": 15593.5491098908, "days": "2022-08-07"},

{"new_game": "Chicago Cubs VS Los Angeles Angels - Baseball", "number_of_user": 12, "paid_amount": 12808.370916370599, "days": "2022-08-04"},

{"new_game": "Miami Marlins VS Minnesota Twins - Baseball", "number_of_user": 9, "paid_amount": 6051.012261177399, "days": "2022-08-02"},

{"new_game": "Colby Covington VS Jorge Masvidal - MMA", "number_of_user": 18, "paid_amount": 14114.635963593002, "days": "2022-08-05"}

]

') as overtime_games_data

overtime_games_data as (select value:new_game as overtime_games, value:number_of_user::int as "Number of User",

value:days as days, value:paid_amount::float as "Volume" from overtime, table (flatten (input => overtime_games_data)))

select * from overtime_games_data

Run a query to Download Data

flipside