McKenzieLab6.txt - Q1 SELECT FIRST_NAME LAST_NAME FROM...

This preview shows page 1 - 2 out of 2 pages.

Q1. SELECT FIRST_NAME, LAST_NAME FROM INSTRUCTOR WHERE SUBSTR(SALUTATION,1,1) = SUBSTR(LOWER{ SALUTATION) WHERE SUBSTR(LAST_NAME,2,3) = SUBSTR(UPPER{ LAST_NAME) WHERE SUBSTR(PHONE,4,5) = SUBSTR(PHONE(XXX-XXX-XXXX),4,5) Q2. SELECT STUDENT.FIRST_NAME, STUDENT.LAST_NAME, STUDENT.ZIP, ZIPCODE.CITY FROM STUDENT INNER JOIN ZIPCODE ON (STUDENT.ZIP=ZIPCODE.ZIP) WHERE ZIPCODE.STATE= 'NY' ORDER BY CITY DESC, ZIP ASC, LAST_NAME ASC; Q3. SELECT Q4. SELECT * FROM INSTRUCTOR WHERE ZIP STATE = 'NY' AND STREET_ADDRESS LIKE '518%'; Q5. SELECT MIN(FINAL_GRADE), MAX(FINAL_GRADE), AVG(FINAL_GRADE) FROM GRADE JOIN GRADE_TYPE Q6. SELECT DISTINCT(STUDENT.STUDENT_ID), STUDENT.FIRST_NAME, STUDENT.LAST_NAME, STUDENT.REGISTRATION_DATE FROM STUDENT JOIN ENROLLMENT ON STUDENT.STUDENT_ID != ENROLLMENT.STUDENT_ID WHERE STUDENT.REGISTRATION_DATE >= '23-FEB-07'; Q7. SELECT COUNT(*) FROM ENROLLMENT, SECTION, INSTRUCTOR WHERE ENROLLMENT.SECTION_ID=SECTION.SECTION_ID AND SECTION.INSTRUCTOR_ID=INSTRUCTOR.INSTRUCTOR_ID

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture