I need to execute below SQL query

Populate the tables with data (using Sequence and Sub Query), ensuring that there are at least 5 people, at least 8 posts, and at least 4 likes. Make sure to use sequences to generate the primary and foreign key values. Most of the fields are self?explanatory. As far as the "content" field in Post, make them whatever you like, such as "Take a look at these new pics" or "Just arrived in the Bahamas", and set the summary as the first 12 characters of the content, followed by "...".

I created following tables -

CREATE TABLE Person (

person_id DECIMAL(12) NOT NULL,

first_name VARCHAR(32) NOT NULL,

last_name VARCHAR(32) NOT NULL,

username VARCHAR(20) NOT NULL,

PRIMARY KEY (person_id)

);

CREATE TABLE Post (

post_id DECIMAL(12) NOT NULL,

person_id DECIMAL(12) NOT NULL,

content VARCHAR(255) NOT NULL,

created_on DATE NOT NULL,

summary VARCHAR(255) NOT NULL,

PRIMARY KEY (post_id),

FOREIGN KEY (person_id) REFERENCES Person

);

CREATE TABLE Likes (

likes_id DECIMAL(12) NOT NULL,

person_id DECIMAL(12) NOT NULL,

post_id DECIMAL(12) NOT NULL,

liked_on DATE,

PRIMARY KEY (likes_id),

FOREIGN KEY (person_id) REFERENCES Person,

FOREIGN KEY (post_id) REFERENCES Post

Consider a SISO transfer function: S P(s) = $2 + 3s + 2 Obtain a state-space representation in the controllable canonical form. Is the system controllable? Observable? Obtain a state-space representation in the observable canonical form. Is your system controllable? Observable? s +1 P(s) = $2 + 3s + 2 Obtain a state-space representation in the controllable canonical form. Is the system controllable? Observable? Obtain a state-space representation in the observable canonical form. Is your system controllable? Observable?1} Determining State Equation The transfer function of a linear system is given by 12(s + 1) am = 3(3 + 3x: + 2)2 Write the state equations in a] The Controllable Canonical form b) The Observable Canonical form :1 Can you write It in Diagonal Canonical form. Why? {1) If your answer to part c is NO, please find closest form to diagonal Canonical form. [Namely Jordan Canonical Form} e. [3.75 pts each] Given the Following shorthand canonical SUP expression: f(x,y,z] =Zm(e,2, 3. :5, T} a. List the complete until table for f{x,y,z}. h. Express f{x,y,z} in Fully expanded SUP canonical Form. c. Express f{x,y,z] in shorthand P05 canonical Form. :1. Express f{x,y,z] in Fully expanded PBS canonical Form. 7- [3-75 PIS each] Given the following shorthand canonical PDS expression: flames]: H M[1,3,4,7,11,12,14} a. List the complete IJ'utJI table for fight}, as}. h. Express f{p,q,r,s] in Fully expanded PBS canonical Form. c. Express f{p,q,r,s] in shorthand SOP canonical Form. d. Express f{p,q,r,s] in Fully expanded 5GP canonical Form. 8-1 Given the following system transfer function Y(s) s + 3 = U(s) $ 2 + 35 + 2 (a) Show its controllability canonical form (b) Show its diagonal controllability canonical form (c) Show its observability canonical form