NUMBER_OF_B_ADDRESS | SUM_OF_B_ADDRESS | AVG_OF_B_ADDRESS | |
|---|---|---|---|
1 | 3 | 15 | 5 |
Ant-DAO-MentCOUNT IF + SUM IF
Updated 2025-03-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with raw_data as (
select 'a' as address, 'week1' as week, 1 as value
union select 'a' as address, 'week2' as week, 2 as value
union select 'a' as address, 'week3' as week, 3 as value
union select 'b' as address, 'week1' as week, 4 as value
union select 'b' as address, 'week2' as week, 5 as value
union select 'b' as address, 'week3' as week, 6 as value
union select 'c' as address, 'week1' as week, 7 as value
union select 'c' as address, 'week2' as week, 8 as value
union select 'c' as address, 'week3' as week, 9 as value
)
select
COUNT(IFF(address = 'b', 1, null)) as number_of_b_address,
SUM(IFF(address = 'b', value, null)) as sum_of_b_address,
AVG(IFF(address = 'b', value, null)) as avg_of_b_address
from raw_data
Last run: about 1 month ago
1
10B
1s