CSE 480 Midterm: CSE 480 MSU Exam 2017 alternate 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 collecting data about some of the professors at msu (in a table named profs ). However, in an email i sent to the department, i realized that i shouldn"t be referring to them by their rst name, because some of the professors share a rst name. Please write a query to nd the rst names that are unique (ordered alphabetically) among the cse professors. You may not use subqueries or joins in your query. And the desired results for this example data: Fill in the blanks when the clause should be used in the select statement:
