How do you select rows from a table where the 'Age' column is greater than 30?A. SELECT * FROM table WHERE Age > 30;B. GET * FROM table IF Age > 30;C. SELECT * FROM table HAVING Age > 30;D. EXTRACT * FROM table WHERE Age > 30;

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);

Students(StudentID, Name, Grade)A Students table is shown above. Which of the following partial SQL query phrases to retrieve data for Students with a grade greater than 60?Question 9Select one:a.Where Grade<60b.Where Grade=60c.Having Grade>60 d.Where Grade>60

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

How do you list all users records with age > 21 in this table?+-------+-------------------------------------------------------------------------------------------------------------------------------+| Table | Create Table |+-------+-------------------------------------------------------------------------------------------------------------------------------+| users | CREATE TABLE `users` ( `id` int(11) DEFAULT NULL, `name` varchar(256) DEFAULT NULL, `age` int(11) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1 |+-------+-------------------------------------------------------------------------------------------------------------------------------+SELECT * FROM users WHERE age < 21;SELECT * FROM users WHERE age IS UP TO 21;SELECT * FROM users WHERE age > 21;SELECT * FROM users WHERE age BETWEEN 21 AND 89;

Consider a table Employee with attributes Name, Age and Branch. Select the SQL query to retrieve the Age and Branch of the youngest Employee over the age of 18 for branches with atleast 10 employees. Select all that apply.