SophiaPretty
$14/per page/Negotiable
Hello,
I only need for the corrections to be made or show me where and how to make the corrections. I am attaching Task1 file which are my answers. Then I will attach a copy of the corrections needed made by my professor. The corrections are in Red. I need this returned by tomorrow afternoon EST which is June 11, 2017. Thanks!
Query 1- SELECT CLASS. Course_No
FROM CLASS
JOIN INSTRUCTOR on CLASS.Instructor_ ID=INSTRUCTOR.INSTRUCTOR_ID
WHERE INSTRUCTOR. LAST_NAME=’Glenn’ and INSTRUCTOR. FIRST_NAME=’Hammer’
Query 2- SELECT COURSE.Course_Name
FROM COURSE
JOIN CLASS
ON COURSE.Course_No=CLASS.Course_No
WHERE CLASS.Instructor_ID=415
Query 3- SELECT INSTRUCTOR. LAST_NAME, FIRST_NAME, OFFICE_NO
FROM INSTRUCTOR
INNER JOIN CLASS
ON INSTRUCTOR. INSTRUCTOR_ID=CLASS.Instructor_ID
INNER JOIN COURSE
ON COURSE. Course_No=CLASS.Course_No
WHERE COURSE.Course_Name=’Psy101’
Query 4- SELECT CLASS.SEMESTER, COUNT(COURSE_NO) AS COURSE
FROM CLASS
GROUP BY SEMESTER-HAVING COURSE>5
Query 5- SELECT ROOM.CAMPUS_NAME, ROOM_NO AS TOTALROOMS
FROM ROOM
Query 6- SELECT INSTRUCTOR.INSTRUCTOR_ID, FIRST_NAME, LAST_NAME
FROM INSTRUCTOR
RIGHT OUTER JOIN APPROVED_INSTRUCTOR
ON APPROVED_INSTRUCTOR.INSTRUCTOR_ID=INSTRUCTOR.INSTRUCTOR_ID
Query 7- SELECT CLASS.Start_Date, Start_Time
FROM COURSE
INNER JOIN CLASS ON COURSE.Course_No=CLASS.Course_No
INNER JOIN INSTRUCTOR
ON INSTRUCTOR.INSTRUCTOR_ID=CLASS.Instructor_ID
WHERE LAST_NAME=’Glenn’ AND FIRST_NAME=’ Hammett’
Query 8= SELECT STUDENT.MAJOR, COUNT(STATUS=’FAILING’) AS FAILEDSTATUS
FROM STUDENT
GROUP BY MAJOR DESC
Query 9= SELECTCOURSE.Course_No, CreditHours
FROM COURSE
INNER JOIN CLASS ON COURSE.Course_No=Class.Course_No
INNER JOIN INSTRUCTOR
ON INSTRUCTOR. INSTRUCTOR_ID=CLASS. Instructor_ID
WHERE LAST_NAME=’Glenn’ AND FIRST_NAME=’Hammett”
Query 10- SELECT CAMPUS. CAMPUS_NAME, PHONE_NO
FROM CAMPUS
JOIN ROOM ON CAMPUS.CAMPUS_NAME= ROOM. Campus_Name
WHERE ROOM.ROOM_NO>25
Attachments:
