SalehUntitled Query
Updated 2022-08-25
9999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- The Core SQL credited to https://app.flipsidecrypto.com/dashboard/QZUd9X
-- I copied and edited it to abtian mine reaserch goals
with game_info as (
select column1 as contract_address, column2 as game_name, column3 as sport
from (values
('0xd67c96fa2d3070085c5ee32104773ccc2dbd21ac','FC Dallas FC vs Inter Miami CF Inter Miami CF','Soccer'),
('0xd19a0d47f44393d238878bc49ce804bef3373647','Colorado Rapids vs Austin FC Austin FC','Soccer'),
('0x840747e4e00c3e012bd93a3cf0bf419a7a01535a','Los Angeles Galaxy vs CF Montréal Montréal','Soccer'),
('0xfc2392649624f561590d76147d07bd19fe14309a','Philadelphia Union vs DC United United','Soccer'),
('0x70121d2255d9f423e5d35462814657656f553110','Chicago Fire vs Columbus Crew','Soccer'),
('0x738a2f1f823656885cb61d18373b47f0f15236ec','Orlando City SC vs Inter Miami CF Inter Miami CF','Soccer'),
('0xa2a3e2f1753ca73898a6d7ae6e511d5f36b89f38','Houston Dynamo vs FC Dallas FC','Soccer'),
('0xb964b9b5c55efa0b7f52389283c4b42ba65e22c4','Real Salt Lake vs Colorado Rapids','Soccer'),
('0xc7e8b40bfc2609becfab32dee7330b687b0611fd','Chicago White Sox vs Minnesota Twins','Baseball'),
('0xb55a10da20ba4f2ddfdb470103143e6baba769dd','Milwaukee Brewers vs Chicago Cubs','Baseball'),
('0x06eb14d138161508f02d517f4d3c792efde1d692','Houston Astros vs Kansas City Royals','Baseball'),
('0xd438a559b880293808079aec4d12432221fc73a5','Arizona Diamondbacks vs San Francisco Giants','Baseball'),
('0x108267d6cd22291568e9260df5c122122de26e83','Oakland Athletics vs Toronto Blue Jays','Baseball'),
('0x6d62cc028082fb750957375129fd3d313867fc60','Los Angeles Dodgers vs Colorado Rockies','Baseball'),
('0xedb993c2532d2dee8e80b1ce9e99bf2531f8d805','Detroit Tigers vs Cleveland Guardians','Baseball'),
('0xe91a8ca5ee5e6bd615039a5595b3d57fca18a488','Chicago White Sox vs Minnesota Twins','Baseball'),
('0x03c2d5cc9e8791afa172b3d0a6f0f50aa110aa44','Milwaukee Brewers vs Chicago Cubs','Baseball'),
('0xd088a349d9e29f002853cb70ec5caf5c5691b9ea','Oakland Athletics vs Toronto Blue Jays','Baseball'),
('0x935fdc590d7e9dc1f72a1c3aff1011c7612a0a41','Cincinnati Reds vs New York Mets','Baseball'),
('0xafc3fb03ea531cf24da1bb41fcb43b696758c1ba','Miami Marlins vs Los Angeles Angels','Baseball'),
('0x074617d7ecb70562ea8f9f5f58c2ae4cba391e8c','Atlanta Braves vs St. Louis Cardinals','Baseball'),
('0x733e2ea88cef947b0f93cb7ac9b401497a3ccf5f','Philadelphia Phillies vs Washington Nationals','Baseball'),
('0x781916f5a2b14cc3568b75a9198d37abc0532705','Pittsburgh Pirates vs New York Yankees','Baseball'),
('0x891f09b247d6ce4305a821ba7a41b09e6defa738','Baltimore Orioles vs Texas Rangers','Baseball'),
('0x87b2abfbaaed7d340932832e455505df5bd1e8dc','Boston Red Sox vs Tampa Bay Rays','Baseball'),
('0x20c291a9d4a3ecad2909195ed2abd01a3e4ed606','Houston Astros vs Kansas City Royals','Baseball'),
('0x0e4024ba819f255c9b0431f6403ed8cead36fe5f','Arizona Diamondbacks vs San Francisco Giants','Baseball'),
('0x879fd211f4b2b8faaef7b5a06481804f6efbb673','Baltimore Orioles vs Los Angeles Angels','Baseball'),
('0x7b0ecb93c3262e6256a3e3b50205585254b7f1d8','Chicago White Sox vs Detroit Tigers','Baseball'),
('0x93f9c47021b8896f45a7586541100c96615069ab','Cincinnati Reds vs Tampa Bay Rays','Baseball'),
('0x84f663b0735ac11f491230f88c3078952951641e','Kansas City Royals vs Cleveland Guardians','Baseball'),
Run a query to Download Data