Which SQL statement will order records by their age field, from youngest to oldest?Instruction: Choose the option that best answers the question. Answer ChoicesORDER BY age youngestORDER BY ageORDER BY age oldestORDER BY age desc

Which SQL statement will order records by their age field, from youngest to oldest?

How do you retrieve the youngest employee's name and age? *SELECT Name, Age FROM Employees ORDER BY Age ASC LIMIT 1;SELECT MIN(Age), Name FROM Employees;SELECT LAST(Name), Age FROM Employees ORDER BY Age DESC;SELECT Name, Age FROM Employees WHERE Age = MIN(Age);

Select the correct answerAmong P, Q, R, S and T, S is older than R but not as old as T; Q is older than only P. Who among them is the youngest?OptionsQPRCan‘t be determined

Select the correct answerWhat is the order of statements in the select statement ?OptionsSELECT FROM WHERE GROUP BY ORDER BY HAVINGSELECT FROM WHERE GROUP BY HAVING ORDER BYNone of theseSELECT WHERE FROM GROUP BY HAVING ORDER BYSELECT FROM GROUP BY WHERE HAVING ORDER BY

Which query is used for sorting data that retrieves all the fields from scholars table and listed them in the ascending order based on their age?