Hello, I need finished work $($screenshots$)$ for the assignment that I attached. and also if something is wrong, or needs to be added, I will let you know

Conclusions $9$

References $10$

$6$

$1$ Goal

Learn about and use various SQL constructs.

Queries codes should be inserted in MS word report like text, not screenshot in picture format.

Take your script from previous works and add queries to this script $($continues work from previous HAs$).$

Submit to Ortus:

MS Word report file names:

DBMS$\_4\_$YourSurname.docx

$\frac{?}{\text{b}\text{a}\text{r}}($ Combined script $(including$ all previous HAs$)in.txt)$ format : DBMS$\_4\_$YourSurname.txt ;

$2$ Task

Create all tables $($and all related objects$)$ and fill tables with data, at least $20$ records in every table;

Create the following types of SQL queries $($tottally at least $10$ queries$)$:

query with one table and multiple conditions in WHERE clause;

query with two related tables and multiple conditions in WHERE clause;

query with grouping GROUP BY;

query with two related tables and query with grouping GROUP BY;

query with grouping and HAVING clause $($conditions for groups$)$;

query with two related tables, grouping and HAVING clause $($conditions for groups$)$;

query with subquery in SELECT clause;

query with subquery in FROM clause;

query with subquery in WHERE clause;

query with subquery in HAVING clause;

query with UNION, INTERSECT, MINUS construction;

query with EXISTS construction;

at least $3$ queries with INNER JOIN;

at least $3$ queries with LEFT JOIN;

at least $3$ queries with RIGHT JOIN;

In queries include:

LIKE together with $"?","*",$ &;

ANY; ALL; IN; BETWEEN; DISTINCT.

TOP $($FETCH$)$

In queries include aggregation functions COUNT$(),$ SUM$(),$ MAX$(),$ AVG$().$

In queries include text and datetime functions.

Conclusions

$$

$6$

$3$ Database description