SQL QUESTION

1. Select all the columns from the students table and order them by last name +-----------+----------+-----------+-------+ | firstname | lastname | city | state | +-----------+----------+-----------+-------+ | Anne | Jones | Here | TN | | Fred | Smith | Here | KY | | Ben | Smith | There | KY | | Ted | Smith | Here | KY | | Jill | Smith | Somewhere | KY | +-----------+----------+-----------+-------+ 5 rows in set (0.00 sec) 2. Select all the columns from the students table and order them by last city +-----------+----------+-----------+-------+ | firstname | lastname | city | state | +-----------+----------+-----------+-------+ | Fred | Smith | Here | KY | | Ted | Smith | Here | KY | | Anne | Jones | Here | TN | | Jill | Smith | Somewhere | KY | | Ben | Smith | There | KY | +-----------+----------+-----------+-------+ 5 rows in set (0.00 sec) 3. Select all the columns from the students table and order them by city and state +-----------+----------+-----------+-------+ | firstname | lastname | city | state | +-----------+----------+-----------+-------+ | Fred | Smith | Here | KY | | Ted | Smith | Here | KY | | Anne | Jones | Here | TN | | Jill | Smith | Somewhere | KY | | Ben | Smith | There | KY | +-----------+----------+-----------+-------+ 5 rows in set (0.00 sec)