Create the following student table and answer the following queries.

 

Table: Student

No	Name	Age	Dept	DateofAdm	Fee	Gender
1	Pankaj	24	Computer	10/01/99	12000	M
2	Shalini	21	History	24/03/20	20000	F
3	Sanjay	22	Hindi	12/12/21	30000	M
4	Sudha	24	History	01/07/21	25000	F
5	Rakesh	22	Computer	27/12/21	30000	M
6	Shakeel	20	Hindi	31/07/99	21000	M

a)     a)  List the names of female students who are in Hindi Department

b)   b) List the names of all the students with their date of admission in ascending order.

c)   c)  Display student’s name,fee and age for male students only.

d)   d) Count the number of students with age <23.

e)   e) Change the fee of students whose fee is <15000.

Source code and Output: