Develop a SELECT statement for each of the following requirements:

$$ Querying the Fact only

$1.$ Display the Number of Orders in the D$\_$ORDERS table.

$2.$ Display the Number of Orders in the F$\_$ORDERS table $($Check that you get the same number from

the dimension table D$\_$ORDERS$).$

$3.$ Display the Lowest, Highest and Average Amount of all Orders.

$4.$ For each customer, display the Lowest, Highest and Average Amount of orders.

$$ Query the Fact and one dimension

$5.$ Display the customers$($id and Name$)$ having an average Amount of orders greater than the double

of the average amount of all orders.

$--->$ You should get $4$ rows.

$6.$ Number of Orders by Salesman $($ID$\_$S and SName are required$)$

$--->$ You should get $4$ rows.

$7.$ Number of Orders by customer $($Id$,$ FName, LName$)$

$8.$ Modify your previous answer to display the Number of Orders and their Total by Customer $($Id$,$

FName, LName$)$ sorted by the number of order descending.

$9.$ Display each Customer $($Id$,$ C$\_$FName, C$\_$LName$)$ having the total amount of its Orders greater

than $80\%$ of the average of all Orders.

$$ Queries using two dimensions and the fact

$10.$ Display the Number of direct Orders $($OMode $=$DIRECT$)$ by Customer $($Id$,$ C$\_$FName, C$\_$LName$)$

and Salesman $($identifier and name$).$

$--->$ You should get $69$ rows.

$11.$ Total Amount of Orders by Year and Customer ID$,$ sorted by Year and Customer.

$--->$ You should get $68$ rows

$$ Simulate the Drill$-$Down operator

$12.$ Transform query $11$ to display the result of the following OLAP operation:

DrillDown$($Q$11,$ D$\_$Time, Quarter$)--$ Where Q$11$ is the result of question $11.$