Please write me a sql code based on the output and test cases, Thank You.

Output: Checks if the job ID exists and checks if Job is still active. If not, print "Invalid Job Post ID$".$ Then find all Job seekers who meet the minimum degree requirement for that job post, the minimal experience for the job post, and the minimal skill required for the job post. For each job seeker found, print out the name of the job seeker and insert a row into the massage table with a newly generated message ID$,$ Account ID$,$ message time and input time, and body of the message is "A job post xxx is available and you are qualified to apply" where xx is the input job post ID$.$

Test cases:

Regular case: JobID $=1,$ timestamp $=$ timestamp $2024-3-210$:$00$:$00*$

Since JoblD $=1$ exists, it checks whether the job post is still active. then proceeds to

find all applicants for the job who satisfy the requirements. Then print out Job seeker name and insert message into message table

Special case: JobID $=444,$ timestamp $=$ timestamp $2024-3-210$:$00$:$00*$

Since JobID $=444$ does not exist, system will print out "Invalid job ID$"$

Special case: JobID $=1,$ timestamp $=$ timestamp $2024-3-210$:$00$:$00\text{'},$ job status not active

$-$ Since JobID exists but job status closed, system will print out "Job is not currently active"