WAP to create the below tables where student refers to stream :
STUDENT:
STREAM:
a) Alter the table to include a column named sex char(1) after lname.
b)Update the sex to 'm' for admission numbers 1001,1003,1005,1007,1010 and 'f' for the others
c)Display the admno , fullname(fname + lname ) and mobile no.
d)Display stream id and stream wise total fee collected
e)Count the number of students from each area
f)Increase the fees of all students by 10%
g)Display the unique areas from the student table
h)Display details of those students who's name starts with 'R' or last name starts with 'S'
i) Display admno,fullname(fname+lname) , class(class+sec) of all the students that belong to xii a and xii b.
j)Display the count of male students and female students
k)Display the admno, fname and stream name of the student
l) Display the count of male students and female students in class xii
m) Display the fees of students in every class/section
No comments:
Post a Comment