Sams Teach Yourself SQL in 24 Hours, Second Edition

Hour 15, "Combining Multiple Queries into One"

Quiz Answers

1:

Is the syntax correct for the following compound queries? If not, what would correct the syntax? Use the EMPLOYEE_TBL and the EMPLOYEE_PAY_TBL shown as follows: EMPLOYEE_TBL     EMP_ID VARCHAR2(9) NOT NULL, LAST_NAME VARCHAR2(15) NOT NULL, FIRST_NAME VARCHAR2(15) NOT NULL, MIDDLE_NAME VARCHAR2(15),   ADDRESS VARCHAR2(30) NOT NULL, CITY VARCHAR2(15) NOT NULL, STATE CHAR(2) NOT NULL, ZIP NUMBER(5) NOT NULL, PHONE CHAR(10),   PAGER CHAR(10),   CONSTRAINT EMP_PK PRIMARY KEY (EMP_ID) EMPLOYEE_PAY_TBL       EMP_ID VARCHAR2(9) NOT NULL, PRIMARY KEY POSITION VARCHAR2(15) NOT NULL,   DATE_HIRE DATE,     PAY_RATE NUMBER(4,2) NOT NULL,   DATE_LAST_RAISE DATE,     SALARY NUMBER(8,2),     BONUS NUMBER(6,2),     CONSTRAINT EMP_FK FOREIGN KEY (EMP_ID) REFERENCES ...