Task 7: Create a procedure to add a row to the INVOICES table. CALL ADD_INVOICE('00001', '2021-11-20', '294') SELECT * FROM INVOICES WHERE INVOICE_NUM = '00001'     PLEASE ANSWER IF YOU KNOW THE ANSWER!!!!!

Task 7: Create a view named MONTHLY_RENTS. It consists of three columns: the first is the number of bedrooms, the second is the average square feet, and the third is the average monthly rent for all properties in the PROPERTY table that have that number of bedrooms. Use BEDROOMS, AVG_SQUARE_FEET, and AVG_MONTHLY_RENT as the column names. Group and order the rows by number of bedrooms. Task 8: Write and execute the command to retrieve the average square footage and average monthly rent for each property for which the average monthly rent is greater than $1,400. Task 9: Without using the MONTHLY_RENTS VIEW, write and execute the command to retrieve the average square footage and average monthly rent for each property for which the average monthly rent is less than $1,400.

Task 1: The StayWell Property Management team wants a list of all property addresses combined with the name of the owners. You will need to return three columns: the first name as FIRST_NAME, the last name as LAST_NAME, and the property address as ADDRESS of the owners. Task Provide the StayWell Property Management team with a list of all property addresses combined with the name of the owners. Task 2: StayWell’s maintenance team wants to recheck the apartments that had plumbing service requests beforehand. You will need to return all the property IDs and the addresses of the properties that had plumbing service request (CATEGORY_NUMBER 1). Task Return a list of all the property IDs and the addresses of the properties that had plumbing service requests. Task 3: The StayWell property management team wants to get in touch with those owners having properties larger than 2,000 square feet. You need to return all the available information of the corresponding owners to the property…

//stored procedure   create or replace procedure firstthree (my_seqid in varchar2) as cursor c1 is     select sname, grade from student s join taken t on s.sid=t.sid       where seqid=my_seqid       order by grade desc; -- my_sname varchar2(40); my_sname student.sname%TYPE; -- my_grade number(2,1); my_grade taken.grade%TYPE; begin /* clear the my_tmp table */ delete from my_tmp; commit;   open c1; for i in 1..3 loop     fetch c1 into my_sname, my_grade;     exit when c1%notfound; /* in case the number requested */                            /* is more than the total */                            /* number of enrolled students */     /* display the result */     dbms_output.put_line('name: ' || my_sname || ' ' || 'grade: ' || my_grade);     /* put into temporary table */     insert into my_tmp values(my_sname, my_grade);     commit; end loop; close c1; end; / -------------- //php <? $connection = oci_connect ("test", "test", "test"); if ($connection == false){    $e = oci_error();…