Answer Happy

The relational tables PARTSUPP, LINEITEM, ORDERS implement a
simple two- dimensional data cube. The relational tables PARTSUPP
and ORDERS implement the dimensions of parts supplied by suppliers
and orders. A relational table LINEITEM implements a fact entity of
a data cube.
Write HQL query for these 2
questions:
For each part list its key (PS_PARTKEY), all its available
quantities (PS_AVAILQTY), and summarized all available quantities.
List the results in the order of increasing results of
summarization. Consider only the parts with the keys 5, 10, 15, and
25.
For each part list its key (PS_PARTKEY), all its available
quantities (PS_AVAILQTY), and summarized all available quantities.
List the results in the order of increasing results of
summarization and supply costs (PS_SUPPLYCOST). Consider only the
parts with the keys 5, 10, 15, and 25.