blazer2024-02-03 01:23 AM
Updated 2024-08-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
--ASSIGNMENT: Using ez-dex-swap table in the ethereum defi database, find top 10 deposit addresses by amount, where platform is uniswap V2.
SELECT -- * Means all
block_timestamp,
tx_hash,
event_name,
contract_address,
symbol_in,
origin_from_address,
amount_in_usd,
platform
FROM ethereum.defi.ez_dex_swaps --Retrieving data from the ethereum.core.ez_token_transfers table
WHERE platform = 'uniswap-v2' and amount_in_usd IS NOT NULL
--GROUP BY amount_usd
ORDER BY amount_in_usd DESC --DESC means descending order -ASC means ascending order
LIMIT 10
QueryRunArchived: QueryRun has been archived