Want to know:

Your database has a table called students that contains the following fields:firstNamelastNameemailAddressphoneYou need to get the firstName, last Name, and email for all students listed alphabetically by last name and then first name.A.) SELECT lastName, firstName FROM students ORDER BY lastName, firstNameB.) SELECT firstName, lastName, email FROM students ORDER BY lastName, firstNameC.) SELECT firstName, lastName, email FROM students ORDER BY firstName, lastNameD.) SELECT firstName, lastName FROM students ORDER BY lastName, firstName

Get a detailed, AI-powered explanation for this question and thousands more on StudyFetch.