Using the relational table ORDERS of the sample database TPCHR and the following index created, construct an appropriate SQL statement and satisfies the following requirement:
create index A1Task3Idx on orders(o_orderdate, o_clerk, o_totalprice);
Find SELECT statements that will use the index in the following ways:
a) Execution of the first SELECT statement must traverse the index vertically and it must not access a relational table ORDERS.