Which code is best to provide the age of each students recorded in the tblstudents?Group of answer choicesSELEC YEAR(NOW()) - YEAR(BDATE) FROM TBLSTUDENTSSELECT STUDNAME AS "NAME OF THE STUDENT", YEAR(NOW()) - YEAR(BDATE) FROM TBLSTUDENTSSELECT YEAR(NOW()) - YEAR(BDATE) AS AGE FROM TBLSTUDENTSSELECT STUDNAME AS "NAME OF THE STUDENT", YEAR(NOW()) - YEAR(BDATE) AS AGE FROM TBLSTUDENTS

Which of the following will output the age of a user with appropriate labels included?Select one:a.cin>>"Age is age";b.cin<<"Age is "<< age;c.cout>>"Age is age";d.cout<<"Age is " << age;

Which of the following will allow the user to read input to collect the value of the variable age?Select one:a.cin<<age;b.cin>>age;c.cout<<age;d.cout>>age;

Consider these following tables and only solve the query. Tables: 1) student: s_no (primary key), student_name, course_no (foreign key), age 2) courser-course-no (primary key), course-name. Query: Display all the student name, course name and also age of the students, whose age is between 23 to 27 and course having 'BCA'. Find out the students whose age is maximum.

Possibility High School maintains a database containing tables related to its students and the subjects offered. Which of the following represents a table within the database?*1 pointa student's namea student's recordall the personal data on studentsthe age of a student

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