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
Conditional Cross Join - Why doesn't this work on the 'ON' clause?
Returning IDs with exactly 3 consecutive months of invoice_amt >2000
filme
simple add function on sql
Assignment 1(SET A)
Descriptor test
Library Query
nasa2
enrj
Q2