CREATE TABLE Using SQL LIVE 1. CREATE TABLE CREATE TABLE SALES_REP (REP_NUM CHAR(2) PRIMARY KEY, LAST_NAME VARCHAR(15), FIRST_NAME CHAR(15), STREET CHAR(15), CITY CHAR(15), STATE CHAR(2), POSTAL_CODE...

Create a table using by SQL Live in the following instruction


CREATE TABLE Using SQL LIVE 1. CREATE TABLE CREATE TABLE SALES_REP (REP_NUM CHAR(2) PRIMARY KEY, LAST_NAME VARCHAR(15), FIRST_NAME CHAR(15), STREET CHAR(15), CITY CHAR(15), STATE CHAR(2), POSTAL_CODE CHAR(5), COMMISSION NUMBER(7,2), RATE NUMBER(3,2) ); 2. INSERT TABLE INSERT INTO SALES_REP VALUES (‘35’,’Lim’,’Louise’,’535 Vincent Dr.’,’Grove’,’CA’,’90092’,0,0.05); 3. USING DESCRIBE DESCRIBE REP; 4. USING SELECT STATEMENT to show table data SELECT * FROM SALES_REP; 5. USING SELECT STATEMENT WITH WHERE CLAUSE for specific condition SELECT CUSTOMER_NAME FROM CUSTOMER WHERE CREDIT_LIMIT >= 10000 6. USING AVG command SELECT TYPE, AVG(DISTANCE), AVG(MAX_GRP_SIZE) FROM TRIP GROUP BY TYPE ( wont be on exam ORDER BY TYPE; (wont be on exam) 7. USING SUM command (Chapter 4) SELECT SUM(CONDO_FEE) FROM CONDO_UNIT 8. USING count (chapter 4) SELECT COUNT(*) FROM CUSTOMER WHERE BALANCE > CREDIT_LIMIT; 9. USING UPDATE, SET and WHERE to update data in a table (Chapter 6 and 4) UPDATE NONGAME SET CATEGORY = NULL WHERE ITEM_NUM = 'FD11';