mirror of
https://github.com/hanzoai/datastore.git
synced 2026-09-26 13:55:07 +00:00
16 lines
504 B
SQL
16 lines
504 B
SQL
SELECT
|
|
n_name,
|
|
sum(l_extendedprice * (1 - l_discount)) AS revenue
|
|
FROM customer, orders, lineitem, supplier, nation, region
|
|
WHERE (c_custkey = o_custkey)
|
|
AND (l_orderkey = o_orderkey)
|
|
AND (l_suppkey = s_suppkey)
|
|
AND (c_nationkey = s_nationkey)
|
|
AND (s_nationkey = n_nationkey)
|
|
AND (n_regionkey = r_regionkey)
|
|
AND (r_name = 'ASIA')
|
|
AND (o_orderdate >= date '1994-01-01')
|
|
AND (o_orderdate < date '1994-01-01' + INTERVAL 1 YEAR)
|
|
GROUP BY n_name
|
|
ORDER BY revenue DESC;
|