a$)$ Create the following two indexes. CREATE INDEX A$2$TASK$1$IDX$1$ ON ORDERS$($O$\_$CLERK, O$\_$ORDERSTATUS$)$; CREATE INDEX A$2$TASK$1$IDX$2$ ON LINEITEM$($L$\_$ORDERKEY$)$; For each one of the $10$ types of different query or data manipulation statements listed below, provide one SQL statement consistent with the respective type and such that processing of SQL statement benefits from at least one of the indices over the relational tables ORDERS and LINEITEM. i$.$ Projection queries $($SELECT without WHERE clause$).$ ii$.$ Selection queries $($SELECT with WHERE claluse$).$ iii. Join queries $($join of two or more relational tables$).$ iv$.$ Queries processed by accessing only an index. v$.$ Group by query $($SELECT with GROUP BY clause and aggregation function$).$ vi$.$ Antijoin query $($SELECT with NOT IN$,$ NOT EX