yesyesconceptual-lime
Updated 2024-10-04
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select avg(replies) as mean_replies,median(replies), date from(
select count(distinct parent_fid) as replies, fid, date_trunc('week', timestamp) as date from external.farcaster.fact_casts
where fid < 100000 and parent_fid is not null and parent_fid != fid
and parent_fid < 100000
and text not like '%$%'
group by 2,3
order by 3 DESC
)
where date < '2024-10-01 00:00:00.000'
group by date
order by date desc
limit 100
QueryRunArchived: QueryRun has been archived