ITM 500 Lecture 4: ITM500 – WEEK 4

• School: Ryerson University
• Department: Information Technology Management
• Course: ITM 500
• Professor: Raymond Moss

Document Summary

Avg gpa for students by major (each major) Select avg(stdgpa) as average gpa , stdmajor from student group by. List the highest student gpa in each major. Select max(stdgpa) as highest gpa , stdmajor, stdname from student. Average gpa for each major but only isplay average about 3. 0. Select avg(stdgpa) as average avg , stdmajor from student group by. Select stdmajor, avg(stdgpa) from student group by stdmajor having count(*) >2. List all details for all students matched with the details of their enrollments inner join = (selects all rows from all tables as long as there are matches) Select * from student inner join enrollment on student, stdssn= enrollment, stdssn. Select * from student inner join enrollment on student, stdssn = enrollment, stdssn. On student, stdssn = enrollment, stdssn where stdname = wells". If you are not interested in wells information and only his enrollment . Select enrollment, * from student inner join enrollment on student, stdssn =