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

Create a database named E$2\_2\_$ID

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

The task is valid when executed on SQL server.

Tasks

$1.$ Find in the database data$\_2024\_1.$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

Product A Product B Number of products Value

$2.$ Your data is in the salesman table. $(3$ points$)$

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

$2022)?$

The solution is a view called sellers.

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

tables.