Week 8 Textbook assignment

Week 8 Textbook assignment - CHAR(3 10 UPDATE EMP_2 SET...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Text activities week 8 Chapter 7: Review Questions: 8, 10, 11 8. CREATE TABLE EMP_2 SELECT EMP_NUM AS EMP_NUM, EMP_LNAME AS EMP_LNAME, EMP_FNAME AS EMP_FNAME, EMP_INITIAL AS EMP_INITIAL, EMP_HIREDATE AS EMP_HIREDATE, JOB_CODE AS JOB_CODE FROM EMP_1; ALTER TABLE EMP_2 ADD (EMP_PCT NUMERIC(4,2)) ADD (PROJ_NUM
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: CHAR(3)); 10. UPDATE EMP_2 SET PROJ_NUM = ‘18’ WHERE JOB_CODE = ‘500’; 11. UPDATE EMP_2 SET PROJ_NUM = ‘25’ WHERE JOB_CODE >= ‘502’; Problems: 16, 17 16. SELECT COUNT (DISTINCT INV_NUM) FROM INVOICE; 17. SELECT COUNT (*) FROM CUSTOMER WHERE CUS_BALANCE > 500.00;...
View Full Document

This note was uploaded on 08/02/2009 for the course IST 210 taught by Professor Mcconn,charlotteryoo,jungwoo during the Summer '08 term at Penn State.

Ask a homework question - tutors are online