i need a little help

this is what i have so far none of the tasks clear

-- Write your query below and then click "Run Query" to execute it. To save multiple queries, click the "+" icon above.

drop table SUMMER_SCHOOL_RENTALS;

CREATE TABLE SUMMER_SCHOOL_RENTALS(

PROPERTY_ID NUMERIC NOT NULL,

OFFICE_NUM NUMERIC NOT NULL,

ADDRESS VARCHAR(100),

SQR_FT SMALLINT,

BDRMS TINYINT,

FLOORS TINYINT,

WEEKLY_RENT SMALLINT,

OWNER_NUM CHAR(5),

PRIMARY KEY(PROPERTY_ID)

);

INSERT INTO SUMMER_SCHOOL_RENTALS(PROPERTY_ID, OFFICE_NUM, ADDRESS, SQR_FT, BDRMS, FLOORS, WEEKLY_RENT, OWNER_NUM) VALUES(13, 1, '5867 Goodwin Ave', 1650, 2, 1, 400, 'CO103');

thanks in advance

Create a table named SUMMER_SCHOOL_RENTALS. The table has the same structure as the PROPERTY table shown on Page 1, except the and OFFICE_NUM columns should use the NUMERIC data type, there should be no BDRMS column, and the column should be changed to WEEKLY_RENT. To see the structure of the table, use the command. Execute the command to describe the layout and characteristics of the table. Task Create the SUMMER_SCHOOL_RENTALS table. The table should be based on > the PROPERTY table. Task 2 Add the following information to a single record in the table: - PROPERTY_ID : 13 , - OFFICE_NUM : 1 , - ADDRESS : 5867 Goodwin Ave, - SQR_FT : 1,650, - BDRMS : 2, - FLOORS : 1 , - WEEKLY_RENT : 400 - OWNER_NUM : CO103 MySQL should return an error that a column does not exist. Determine which column in the above list is not in the SUMMER_SCHOOL_RENTALS and remove it. Run the query again to add the record to the table. Task Add the provided record to the SUMMER_SCHOOL_RENTALS table. Determine which item does not belong to the table and remove it. Check that the database is back to its starting point. The database should have the six tables shown on page 1 of this lab