An incorrect database name $\text{'}$on the server' will disqualify the task. $(148\mathrm{.}81\mathrm{.}196\mathrm{.}51$LLABSQLSVR$01,50067).$

Create a database named E$20230529\_$group$\_$ID$-$

ID is your$-$ID at the university $($group is the group number$)9$

The task' is valid when 'executed'on'SQL'server. $9$

Tasks

$$ Find in the database exam$\_$data$\_2023\_05\_29.$txt: $,(3$ points$)$

the pair of products that generated the most revenue in the second quarter $-2021.$ The solution is a$-$

view called'sell.

It'should look$-$like

Check if your data is in the seller table.

The table is in relation to the product table.

Who sold the same products $($at $-$least one product$)$ with You in your birthday month $($year$-2021$ and

$?$

The$-$solution $\text{'}$is a view called sellers. uarr

$$ Create $-$ a tables as shown in the picture and use $($write$)$ triggers for updates and for inserting data in $-$

tables.: $,,,,(33$ points$)$