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

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.

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;

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 statement is used to get all data from the student table whose name starts with p?SELECT * FROM student WHERE name LIKE '%p%';SELECT * FROM student WHERE name LIKE 'p%';SELECT * FROM student WHERE name LIKE '_p%';SELECT * FROM student WHERE name LIKE '%p';

Select the query to display all the columns from the student table whose score is in the range of 80 to 90.