CSE 480 Midterm: CSE 480 MSU Exam 2017 regular Exam
31 Jan 2019
School
Department
Course
Professor
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"ve been grading exams and looking for the poor-performing students, using the stu- dents" rst and last names. Fortunately, no two students are allowed to have the same. Rst and last name, else they will be expelled. However, d2l only lets me enter grades with their student ids, so i"ll need 2 tables to solve my problem. I need a query to identify the student(s) who either didn"t take the exam (and hence aren"t in the table grades) or who scored below a 15. I want just the students" ids (ordered by alphabetically).
