# Database: Examples: University: Exercises: Simple Selects

Name __________________________________________
These questions all apply to the University database.

1. Print the entire student table.
2. Print the first and last names of all students.
3. Print the last name, then first name of all students in ascending alphabetical order The last names should be in alphabetical order, and where two students have the same last name, the first names should be in order.
4. Print all the first names in ascending alphabetical order, but do not repeat any names.
5. Print the GPA with the last and first names for all students whose GPA is at least 3.0, in the order of descending GPA.