Hello! Help me with SQL$,$ please!

We have following tables from database $\_$adventureworkslt:

CREATE TABLE plan$\_$status $($

quarterid varchar$(6)$ NOT NULL,

status varchar$(10)$ NOT NULL,

modifieddatetime timestamp DEFAULT CURRENT$\_$TIMESTAMP NOT NULL,

author varchar$(20)$ DEFAULT CURRENT$\_$USER NOT NULL,

country varchar$(5)$ NOT NULL,

CONSTRAINT plan$\_$status$\_$pk PRIMARY KEY $($quarterid$,$ country$)$

$)$;

CREATE TABLE country$\_$managers $($

username varchar$(30)$ NOT NULL,

country varchar$(5)$ NOT NULL,

CONSTRAINT country$\_$managers$\_$pk PRIMARY KEY $($username$,$ country$)$

$)$;

Write two functions in python:

$$ set$\_$lock$($year$,$ quarter, user, pwd$),$ which will change status from R to L for records in

plan$\_$status, that are associated with the target quarter and year, and connected to the current

user in the country$\_$managers configuration table. To obtain the name of the current user, use

current$\_$user. Also write a timestamp of modification to the modifieddatetime field.

$$ remove$\_$lock$($year$,$ quarter, user, pwd$)$ function, that will change the planning data status from

L to R$.$ associated with the current user through the country$\_$managers table. Also update the

modifieddatetime field.

Execute the set$\_$lock function to lock the plan data for the $1$st quarter of $2014$ on behalf of Kirill user,

and then $$ Sophie. If everything is done correctly, data will appear in the v$\_$plan$\_$edit view if

connected as Kirill or Sophie.

Increase the planned sales volume per country per category for the plan period by about $30-50\%$ in the

v$\_$plan$\_$edit view on behalf of two managers. You can edit data through the view in DBeaver using a

virtual key $($it must contain all fields except salesamt$).$

Run the function remove$\_$lock to mark Q$12014$ as not in use. Run this function as Kirill and then as

Sophie. Now the v$\_$plan$\_$edit view will return no records.

Rules for updating the plan$\_$status table are listed below:

Column $|$Description $|$Rules$||$

quarterid $|$Key of planning quarter $|$No changes$||$

sountry $|$Country of a shop which orders goods $|$No changes$||$

status $|$Plan data slice status $|$L$||$

modifieddatetime $|$Time when the record was changed or created $|$Value of current$\_$timestamp$||$

author $|$User that changed the record $|$Value of current$\_$user$||$

Tables used

Plan$\_$status table should be updated. Country$\_$managers stores information about users$$ permissions regarding plan sales to different countries.