Answered step by step
Verified Expert Solution
Question
1 Approved Answer
FAIDES FALL 202 From the below students table, please select a query to find out youngest student in the table? student_id name age dept_id John
FAIDES FALL 202 From the below students table, please select a query to find out youngest student in the table? student_id name age dept_id John Smith 1 2 3 5 22 Mary Johnson 20 2 David Lee Karen Chen Tom Baker 23 1 21 3 19 4 None of the above choices. O SELECT name, age FROM Students WHERE age = (SELECT COUNT(age) FROM Students); O SELECT name, age FROM Students WHERE age = (SELECT MAX(age) FROM Students); OSELECT name, age FROM Students WHERE age = (SELECT MIN(age) FROM Students); O SELECT name, age FROM Students WHERE age = (SELECT AVG(age) FROM Students)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started