Create a database named E$2\_1\_$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 $2021,$ in the month of your birthday. The

solution is a view called sell$\_$ID$.$

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?

The solution is a procedure sellers with default parameter $($your ID$)$

$3.$ Create a table as shown in the picture and write a procedure to add unique data to the tables.

If the added data exists in the table, the procedure should return the id of this data, if this data is

missing, it should add the data and also return the id$.(3$ points$)$

Prepare a script with the solution and save it in a file $($ID$\_$student$\_$surname$\_$name.TXT$)$ with the TXT

extension.

Place the file on the Platon platform in: Training path elements $-$ Introduction to Database Lab

exam$\_2\_11$