Question

For the given table “Student”, write down the SQL query for the following:
a. Find the complete record of students whose age comes in the range from 18 to 31.
b. Find the complete details of students who have taken birth on August 4, 1999.
c. Find the total count of students present in this table.
d. Find the record of students who resides either in City Loco or in London.
e. Find the complete details of students whose name has third letter as „r‟.
f. Find Student Id, FirstName and Last Name of all the students in Ascending order as per the
FirstName of students.

Answer 1

Answer:

refer to the attachment drop some thx plz