SELECT
c.customer_id,
o.amount,
PERCENT_RANK() OVER (ORDER BY o.amount) AS percent_rank,
DENSE_RANK() OVER (ORDER BY o.amount DESC) AS dense_rank
FROM orders o
LEFT JOIN customers c
ON c.customer_id = o.customer_id;
Ketika mendengar kata programmer, kebanyakan orang mungkin langsung membaginya menjadi dua kategori, yaitu Frontend Developer dan Backend De...
No comments:
Post a Comment