CSE 480 Midterm: CSE 480 MSU Exam 2018 sample Exam

40 views19 pages

Document Summary

Answer the questions in the spaces provided on the page. If you run out of room for an answer, continue on the back of that page. Unnamed pages may be lost: if you start to answer a question and then change your mind, please cross out the attempt and write do not grade across it. I have 2 tables containing information about athletes and teams. The table athletes has the following columns: name (the athlete"s name, unique), year (the graduating year of the athlete), team (the id of the team the athlete is part of), and grade (the athlete"s. The table teams has tho following columns: name (the team"s name), id (the team"s identi cation number, unique), and school (the name of the team"s school). I want to know (for each team) what the was the average grade of the students who played for that team. However, i am only concerned with teams with more than one player.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers

Related Documents