flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
2023-08-05 10:22 PM
oooooblah
2023-08-05 10:22 PM
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
u
.
user_id
,
u
.
username
,
COUNT
(
i
.
item_id
)
AS
total_items_owned
FROM
ethereum
.
core
.
fact
u
LEFT
JOIN
items
i
ON
u
.
user_id
=
i
.
owner_id
GROUP
BY
u
.
user_id
,
u
.
username
;
Results
Run a query to Download Data