Question

5. Look at the table “ Student” given below and solve the following:-

Admno Sname Class Address gender

123 rahul 12a jmt Male

124 puja 12a dhn Female

125 sundar 12b NULL Male

126 rajan 12a jmt Male

a) Write the code to create the table “student” above.

b) Write the code to Insert the value in a table all three rows

c) Write the sql query to display all the data from the table

d) Write the query to display the names of all the male students.

e) Display all the details of students who belong from jmt

f) Display the details of all the student whose address is not given.

g) Display unique address from student table

h) Display all the details of students arranged in descending order of their name.

i) Display admno and name of those students who belong from ’ 12a’ and ‘12b’

j) Display all the details whose class is 12a arranged in ascending order of their name.​

Answer 1

Answer:

ufufufiififufufufifufufififjfifjdudufjfifif

Explanation:

hhghggggffdfdc