The SQL query to output the contents of the EMPLOYEE table sorted by last name, first name, and initial is _____.
A) SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE LIST BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
B) SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE ORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
C) SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE DISPLAY BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
D) SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE SEQUENCE BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;

Question

Quizplus · Accepted Answer

The keyword to sort by a column is "ORDER BY" and not "LIST BY" or "SEQUENCE BY". The keyword to output the result is "SELECT" and not "DISPLAY". Therefore the correct query would be: 
SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE 
FROM EMPLOYEE 
ORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;

The SQL Query to Output the Contents of the EMPLOYEE