Question#$3$:

$($Select all answers that are true$)$

Which of the following SQL queries uses proper syntax and displays sales reps in the city of Auburn sorted by last name and then on first name $($select all that are correct$)$:

a$)$ SELECT $*$ FROM rep WHERE city is 'Auburn' ORDER BY last$\_$name, first$\_$name;

b$)$ SELECT $*$ FROM rep WHERE city $=$ 'auburn' ORDER BY last$\_$name DESC, first$\_$name ASC;

c$)$ SELECT $*$ FROM rep WHERE city $=$ 'Auburn' ORDER BY last$\_$name, first$\_$name DESC;

d$)$ SELECT $*$ FROM rep WHERE city $=$ 'Auburn' ORDER BY last$\_$name AND first$\_$name;