Write me a simple sql code based on the Job$\_$Post I am going to provide. Please answer me correctly, I will give you a thumbs up$.$

The Job$\_$Post code:

drop table seach$\_$job$\_$post cascade constraints;

create table search$\_$job$\_$posts $($

jobid number primary key,

cname varchar$2(100),$

jtitle varchar$2(100),$

jdescribe varchar$2(500),$

min$\_$pay number,

max$\_$pay number,

j$\_$city$2$ varchar$2(50),$

j$\_$states$2$ varchar$2(50),$

job$\_$type varchar$2(20),$

j$\_$status varchar$2(20),$

Primary key $($Jobid$),$

Foreign key $($accid$)$ REFERENCES account$\_$t$($accid$),$

Foreign key $($compID$)$ REFERENCES company$($compID$)$

$)$;

insert into search$\_$jobposts VALUES $(1,$ 'ABC Company', 'Software Engineer', 'Seeking experienced software engineer', $60000,80000,$ 'Example City', $\text{'}$CA$\text{'},$ 'full time', 'active'$)$;

insert into search$\_$jobposts VALUES $(2,\text{'}$XYZ Corporation', 'Data Analyst', 'Looking for a skilled data analyst', $50000,70000,$ 'Another City', $\text{'}$NY$\text{'},$ 'part time', 'active'$)$;

insert into search$\_$jobposts VALUES $(3,\text{'}123$ Inc.$\text{'},$ 'Marketing Specialist', 'Join our marketing team', $45000,60000,$ 'Cityville', $\text{'}$CA$\text{'},$ 'full time', 'inactive'$)$;

I need something similar for my feature as well:

MY feature which need to be answered:

Feature $7$: Generate job alerts. The input is a job post ID and a timestamp. The procedure does the following:

$1)$ it first checks whether there is a job post with the input ID and is still active. If there is no such a job post, print a message 'Invalid job post ID$\text{'}$ and stop.

$2)$ it then finds all job seekers who satisfy ALL of the following conditions:

a$)$ the job seeker's highest degree meets the minimal degree requirement of the job post $($if you use $1$ for associate degree, $2$ for bachelor, $3$ for master's and $4$ for doctoral degree, then the highest degree $>=$ minimal degree of the job post$)$;

b$)$ the job seeker's number of years of work experience is greater or equal to the minimal experience of the job post;

c$)$ for each skill required by the job post, the job seeker has that skill and the skill level is greater or equal to required level.

$3)$ for each job seeker found in step $2),$ print out the name of the job seeker and insert a row into the message table with a newly generated message ID$,$ account ID as the job seeker's account ID$,$ message time as the input time, and body of the message is 'A job post X is available and you are qualified to apply' where X is the input job post ID$.$