SQL code solution and database on SQL server.

Create a database named E$2\_3\_$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 lowest revenue in December $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 with You in July? The solution is a view called sellers.

$3.$ Create a table as shown in the picture and write a procedure to add unique country$\_$name to the tables. If the added data exists in the table, the procedure should return the id of this country$\_$name, if this data is missing, it should add the data and also return the id$.(3$ points$)$