Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Yandex Task
select customer_age, merchant_type_id, round(avg(transaction_sum), 0) as avg_transaction, count(1) as category_count, row_number() over (partition by customer_age order by count(1) desc, merchant_type_id asc) as ordinal_position from "public"."Customers" inner join "public"."Transactions" using(customer_id) inner join "public"."Merchants" on "public"."Merchants".merchant_id = "public"."Transactions".merchant_id group by customer_age, merchant_type_id;
run
|
edit
|
history
|
help
0
Final 1
Current time/date, timezone
SQL Movie-Rating Query Exercises
m,,nm,
fgf
OLA
filme
prueb final
Product Sales Analysis I - III
SQL3