Q-1.
)Create a student table with the student
ID,Name,Class,DOB and marks as attributes
where the student ID is primary key.
Q-2.)Insert the details of a new student in the above
table.
Q-3.)Display all details of all students.
Q-4.)Use the select command to get the details of the
students with marks more than 80.
Q-5.)Display details of students of class X and XII.
Q-6.)Delete the details of a particular student in the
above table
Q-7.)Increase marks of all students by 5 who have
scored less than 30.
Q-8.)Add a new column phone_no. in the students
table.
Q-9.) Display the student table in descending order of
the marks.
Q-10.) Find the unique class name from the table.
Q-11.) Display name of students whose names are
starting with ‘A’.
Q-12.) Find the min, max, sum, and average of the
marks in a student marks table.
Q-13.)Display names of students who are having their
birthday in the current month.
Q-14.) Display details of students who are born before
2010.
.
Q-15.) Display length of the names joined with
admission no., along with names of students.
Q-16.)Display the number of students in each class.
Q-17.) Create two new table order (order ID, customer
ID and order date) and customer ( customer ID,
customer name, contact name, country).
Q-18.)Create a foreign key in one of the two tables
mentioned above.
