Mis6326

1) SELECT StdNo, StdFirstName, StdLastName

FROM Student

WHERE StdMajor = 'IS' AND StdGPA > 3.50

2) SELECT StdNo

FROM Enrollment,Offering

WHERE CourseNo LIKE 'FIN%'

AND Offering.OfferNo=Enrollment.OfferNo

3) SELECT Student.StdNo, StdFirstName, StdLastName, StdMajor, StdGPA

FROM Student, Enrollment, Offering

WHERE CourseNo = 'IS480' AND OffTerm = 'WINTER'

AND Student.StdNo = Enrollment.StdNo

AND Offering.OfferNo = Enrollment.OfferNo

4) SELECT OfferNo, Offering.CourseNo, CrsDesc

FROM Offering, Course

WHERE OffTerm = 'SUMMER' AND FacNo IS NULL

AND Offering.CourseNo = Course.CourseNo

or

SELECT OfferNo, Course.CourseNo, CrsDesc

FROM Offering, Course

WHERE OffTerm = 'SUMMER' AND FacNo IS NULL

AND Offering.CourseNo = Course.CourseNo

5) SELECT DISTINCT CourseNo

FROM Student, Enrollment, Offering

WHERE Offering.OfferNo=Enrollment.OfferNo

AND Enrollment.StdNo=Student.StdNo

AND (StdMajor = 'IS' OR StdMajor = 'FIN')

AND StdClass = 'SR'

6) SELECT COUNT(CourseNo) AS NoOfOffers

FROM Offering

WHERE FacNo IS NULL

7) SELECT StdMajor, MIN(StdGPA) AS MinGPA

FROM Student

WHERE StdClass IN ('JR','SR')

GROUP BY StdMajor

HAVING AVG(StdGPA) < 3.0

8) SELECT StdMajor, MAX(StdGPA) AS MaxGPA

FROM Student

WHERE StdClass IN ('JR','SR')

GROUP BY StdMajor

HAVING AVG(StdGPA) > 3.0

9) SELECT OffYear, OffTerm, COUNT(DISTINCT OfferNo) AS NumOfferings, COUNT(DISTINCT CourseNo) AS NumCourses

FROM Offering

GROUP BY OffYear, OffTerm

ORDER BY OffTerm ASC

10) SELECT CourseNo, Offering.OfferNo, AVG(EnrGrade) as AvgGrade

FROM Offering, Enrollment

WHERE OffTerm = 'SPRING' and OffYear = '2013' AND CourseNo LIKE 'IS%'

AND Enrollment.OfferNo = Offering.OfferNo

GROUP BY CourseNo, Offering.OfferNo

HAVING COUNT(*)>4

ORDER BY CourseNo ASC, AvgGrade DESC

13) SELECT TOP 1 StdLastName, StdFirstName

FROM Student

ORDER by StdLastName DESC, StdFirstName DESC

17) select distinct CourseNo

from Offering

where CourseNo not in (select...