flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
[08] MDAO 101: SQL WHERE LIKE (2)
metricsdao
[08] MDAO 101: SQL WHERE LIKE (2)
Updated 2022-12-24
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
-- MetricsDAO Blockchain Analytics 101
-- https://docs.metricsdao.xyz/analyst-resources/blockchain-data-101
select
distinct
pool_name
from
ethereum
.
core
.
ez_dex_swaps
where
pool_name
like
'ENS-%'
or
pool_name
like
'%-ENS LP'
limit
100
;
Results
Run a query to Download Data