$6$

$1$ Goal

Learn about and use various SQL constructs.

$2$ Task

Create at least $2$ views

Create at least $2$ materialized views

Create the following SQL queries:

Using CASE expression $-$ at least $2$ queries

Hierarchical queries using:

START WIDTH, CONNECT BY and LEVEL $-$ at least $1$ query;

WITH, UNION ALL $-$ at least $1$ query;

Using analytical functions OVER, PARTITION BY$,$ ORDER BY$,$ RANK, DENSE$\_$RANK, ROW$\_$NUMBER, FIRST, LAST, NTILE, WIDTH$\_$BUCKET $-$ at least $2$ queries;

Using windowing function ROWS, RANGE, BETWEEN, UNBOUNDED, PRECEDING, FOLLOWING, CURRENT ROW $-$ at least $2$ queries;

Create at least $3$ dimensions tables and one fact table and create queries using GROUP BY CUBE, GROUPING$(),$ GROUPING SETS at least $2$ queries;

Create one table with at least $3$ dimensions attributes and one fact attribute. Create queries using MODEL, PARTITION BY$,$ DIMENSION BY$,$ MEASURES, RULES $-$ at least $2$ queries.

Conclusions

Submit to Ortus:

a$.$ Report file in MS Word format names: DBMS$\_5\_$Surname.docx

b$.$ Sql script: DBMS$\_5\_$Surname.txt

$6$

${?}_3$ Database description

$$ Database physical model $>>$

$6$

$4$ SQL queries

$4\mathrm{.}1$ Query#$1$ name

Query goal

Query SQL code

Result of execution

Analysis of results, what in these data can be seen$>>$

$4\mathrm{.}2$ Query#$2$ name

Query goal

Query SQL code

Result of execution

Analysis of results, what in these data can be seen

hello, i need to finished work $($screenshots$)$ for assigment that I attached. and also something is wrong, or needs to be added, I will let you know