metricsdao[06] MDAO 101: SQL WHERE OR - duplicate
Updated 2022-08-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
-- MetricsDAO Blockchain Analytics 101
-- https://docs.metricsdao.xyz/analyst-resources/blockchain-data-101
select
*
from ethereum.core.fact_transactions
where (from_address = '0x66b870ddf78c975af5cd8edc6de25eca81791de1'
or from_address = '0xc564ee9f21ed8a2d8e7e76c085740d5e4c5fafbe')
and block_timestamp >= '2022-07-21'
and to_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
-- try running the query with the below where clause instead of the above
-- notice anything different ?
-- where from_address = '0x66b870ddf78c975af5cd8edc6de25eca81791de1'
-- or from_address = '0xc564ee9f21ed8a2d8e7e76c085740d5e4c5fafbe'
-- and block_timestamp >= '2022-07-21'
limit 100;
-- side note on comments:
-- (commented out lines will be ignored when the query is run)
-- any line can be commented out by adding -- to the start of the line
-- simply delete the -- to "enable" the line
Run a query to Download Data