Question

Consider the following table and write the output of the following SQL Queries.

Table: Student

StudentID	Name	DateofBirth	Marks	City
301	Aryan	15-03-2005	88	Delhi
302	Ayesha	NULL	90	NULL
304	Aditi	NULL	85	Pune
305	Rajesh	11-01-2006	72	NULL
306	Maria	29-04-2005	95	Chennai

Write the output of the following SQL Queries.

1. SELECT Name, LENGTH(Name) FROM Student WHERE
   StudentID < 303;

2. SELECT lower(Name) FROM Student WHERE
   MONTH(DateofBirth)= 3;

3. SELECT AVG(Marks) FROM Student;

4. SELECT Name, Marks FROM Student WHERE Marks
   BETWEEN 90 AND 100;

Answer 1

1. 
   

   Name	LENGTH(Name)
   Aryan	5
   Ayesha	6

2. 
   

   lower(Name)

   aryan

3. 
   

   AVG(Marks)

   86.0000

4. 
   

   Name	Marks
   Ayesha	90
   Maria	95