Question

2. Create the following tables

student_details {register_no, student_name, DOB, address, city}

mark_details {register_no, mark1, mark2, mark3, total }

 Display only those rows whose total ranges between 250 and 300.

 Drop the table mark_details and Delete the row whose register_no=161.

 Display all details whose names begins with 'a'.​

Answer 1

Answer:

you can do it in mobile also

Answer 2

Answer:

student_details {register_no, student_name, DOB, address, city}

mark_details {register_no, mark1, mark2, mark3, total }

 Display only those rows whose total ranges between 250 and 300.

 Drop the table mark_details and Delete the row whose register_no=161.

 Display all details whose names begins with 'a'.