Est. Budget: $50.00
This task is to use the RANK and WINDOW features of SQL/OLAP as supported by Oracle.
I have supplied the foodmart database needed in mdb access format and link to it in oracle format ( Answer must be in ORACLE OLAP SQL):(Note that you only need five tables from the database for the solution, you can ignore the
rest . The five tables are
SALES_FACT_1998 (excluding Dec 1998 data)
SALES_FACT_DEC_1998 (Dec 1998 data)
Database is ...