Display na for zip city and state if an instructor

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

We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
MIS
The document you are viewing contains questions related to this textbook.
Chapter 3 / Exercise 6
MIS
Bidgoli
Expert Verified
city, and state. Display "N/A" for zip, city, and state if an instructor does not havea zipcode. (HINT: left join INSTRUCTOR and ZIPCODE; use NVL function)Q4. Show the number of instructors who live in NY state and has a street numberof 518. (HINT: use string functions such as SUBSTR and INSTR)Q5. Display the lowest, highest, and average numeric grade of Project grade type. (HINT: use the MIN, MAX, and AVG function; join GRADE and GRADE_TYPE)-- LEFT JOIN, DATEQ6. List all students (display student_id, first name, last name, and registration date) who registered on or before 2/15/2007 but have not enrolled in any course.(HINT: left outer join STUDENT and ENROLLMENT; use the TO_DATE function)-- COUNT WITH 3-TABLE JOINQ7. Find how many students are enrolled in sections taught by Todd Smythe. (HINT: join INSTRUCTOR, SECTION, and ENROLLMENT)-- 4-TABLE JOINQ8. Show all students who are taking, or have taken the course "Advanced Java Programming course". List student name, enrollment date, and section location.
We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
MIS
The document you are viewing contains questions related to this textbook.
Chapter 3 / Exercise 6
MIS
Bidgoli
Expert Verified
(HINT: join COURSE, SECTION, ENROLLMENT, and STUDENT)-- 4-TABLE JOINQ9. List the students who have received any numeric grade score of at least 95 in an Advanced Java Programming course. Show student name, the grade type code, and the numeric grade.-- 4-TABLE JOIN WITH DISTINCTQ10. List the instructors who teach Advanced Java Programming (having a section with students enrolled), without duplication. Show instructor name and course name. (HINT: use the DISTINCT keyword)Learning Resources

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture