@ShirlyR

CREATE TABLE PROPERTY ( PROPERTY_ID INT (2) PRIMARY KEY, OFFICE_NUM INT (1), ADDRESS CHAR (25), SQR_FT INT (4), BDRMS INT(1), FLOORS INT(1), MONTHLY_RENT INT (4), OWNER_NUM CHAR(5) );

CREATE TABLE PROPERTY ( PROPERTY_ID INT (2) PRIMARY KEY, OFFICE_NUM INT (1), ADDRESS CHAR (25), SQR_FT INT (4), BDRMS INT(1), FLOORS INT(1), MONTHLY_RENT INT (4), OWNER_NUM CHAR(5) );

CREATE TABLE OWNER ( OWNER_NUM CHAR (5) PRIMARY KEY, LAST_NAME VARCHAR (10), FIRST_NAME VARCHAR (10), ADDRESS CHAR (25), CITY VARCHAR (10), STATE CHAR(2), POSTAL INT(5) ); INSERT INTO OWNER

CREATE TABLE PROPERTY ( PROPERTY_ID INT (2) PRIMARY KEY, OFFICE_NUM INT (1), ADDRESS CHAR (25), SQR_FT INT (4), BDRMS INT(1), FLOORS INT(1), MONTHLY_RENT INT (4), OWNER_NUM CHAR(5) );

CREATE TABLE CUSTOMER ( CUST_ID INT (3) PRIMARY KEY, FIRST_NAME VARCHAR (10), LAST_NAME VARCHAR (10), ADDRESS CHAR (25), CITY VARCHAR (10), STATE CHAR(2), POSTAL INT(5), EMAIL VARCHAR (30), BALANCE DECIMAL (5,2),

CREATE TABLE ITEM ( ITEM_iD CHAR(4) PRIMARY KEY, DESCRIPTION VARCHAR (50), ON_HAND INT (2), CATEGORY CHAR (3), LOCATION CHAR(1), PRICE DECIMAL (5,2) ); INSERT INTO ITEM VALUES

-- List all details about all items. Order the output by description. CREATE TABLE ITEM ( ITEM_iD CHAR(4) PRIMARY KEY, DESCRIPTION VARCHAR (50), ON_HAND INT (2), CATEGORY CHAR (3), LOCATION CHAR(1), PRICE DECIMAL (5,2) ); INS

-- Find the ID, first name, and last name of each customer whose -- first name begins with the letter “S.” CREATE TABLE CUSTOMER ( CUST_ID INT (3) PRIMARY KEY, FIRST_NAME VARCHAR (10), LAST_NAME VARCHAR (10), ADDRESS CHAR (25),

-- List the property ID and office number for every property whose -- square footage is equal to or less than 1,400 square feet. CREATE TABLE PROPERTY ( PROPERTY_ID INT (2) PRIMARY KEY, OFFICE_NUM INT (1), ADDRESS CHAR (25), SQR_FT

-- List the last name and first name of every owner who lives in Seattle. CREATE TABLE OWNER ( OWNER_NUM CHAR (5) PRIMARY KEY, LAST_NAME VARCHAR (10), FIRST_NAME VARCHAR (10), ADDRESS CHAR (25), CITY VARCHAR (10), STATE CHAR(

-- List the complete PROPERTY table (all rows and all columns) CREATE TABLE PROPERTY ( PROPERTY_ID INT (2) PRIMARY KEY, OFFICE_NUM INT (1), ADDRESS CHAR (25), SQR_FT INT (4), BDRMS INT(1), FLOORS INT(1), MONTHLY_RENT INT

-- List the owner number, last name, and first name of every property owner. CREATE TABLE OWNER ( OWNER_NUM CHAR (5) PRIMARY KEY, LAST_NAME VARCHAR (10), FIRST_NAME VARCHAR (10), ADDRESS CHAR (25), CITY VARCHAR (10), STATE CH

-- Use the IN operator to list the item ID and description of each --item in category FSH or BRD CREATE TABLE ITEM ( ITEM_iD CHAR(4) PRIMARY KEY, DESCRIPTION VARCHAR (50), ON_HAND INT (2), CATEGORY CHAR (3), LOCATION CHAR(1),

-- List the item ID and description of each item that is not in category HOR. CREATE TABLE ITEM ( ITEM_iD CHAR(4) PRIMARY KEY, DESCRIPTION VARCHAR (50), ON_HAND INT (2), CATEGORY CHAR (3), LOCATION CHAR(1), PRICE DECIMAL (5,2

-- List the first and last names of customers with credit limits -- of $1,000 or more CREATE TABLE CUSTOMER ( CUST_ID INT (3) PRIMARY KEY, FIRST_NAME VARCHAR (10), LAST_NAME VARCHAR (10), ADDRESS CHAR (25), CITY VARCHAR (10),

-- List all rows and columns for the complete INVOICES table. CREATE TABLE INVOICES ( INVOICES_NUM INT (5) PRIMARY KEY, INVOICES_DATE DATE, CUST_ID INT(3) ); INSERT INTO INVOICES VALUES (14216, '2021-11-15', 125), (14219, '2

-- List the item ID, description, and price for all items CREATE TABLE ITEM ( ITEM_iD CHAR(4) PRIMARY KEY, DESCRIPTION VARCHAR (50), ON_HAND INT (2), CATEGORY CHAR (3), LOCATION CHAR(1), PRICE DECIMAL (5,2) ); INSERT INTO ITE

CREATE TABLE SUMMER_SCHOOL_RENTALS ( PROPERTY_ID NUMBER (2) PRIMARY KEY, OFFICE_NUM NUMBER (2), ADDRESS CHAR(25), SQR_FT DECIMAL(5,0), BDRMS DECIMAL(2,0), FLOORS DECIMAL(2,0), WEEKLY_RENT DECIMAL(6,2), OWNER_NUM CHAR

CREATE TABLE SUMMER_SCHOOL_RENTALS ( PROPERTY_ID NUMBER (2) PRIMARY KEY, OFFICE_NUM NUMBER (2), ADDRESS CHAR(25), SQR_FT DECIMAL(5,0), BDRMS DECIMAL(2,0), FLOORS DECIMAL(2,0), WEEKLY_RENT DECIMAL(6,2), OWNER_NUM CHAR

CREATE TABLE SUMMER_SCHOOL_RENTALS ( PROPERTY_ID NUMBER (2) PRIMARY KEY, OFFICE_NUM NUMBER (2), ADDRESS CHAR(25), SQR_FT DECIMAL(5,0), BDRMS DECIMAL(2,0), FLOORS DECIMAL(2,0), WEEKLY_RENT DECIMAL(6,2), OWNER_NUM CHAR