This database created by me. I hope this database would be interesting for Harry Potter lovers.
Consider the database of Hogwarts School of Witchcraft and Wizardy.
Student Table
House Student
House
House_Head
Instructor
i. Find the Student details whose name ends with “Potter".
ii. Find out the name of the teacher who teaches "Potions".
iii. Show the names of the students who belong to the Pure Blood in descending order.
iv. Find out the name of the head instructor of "Gryffindor” house".
v. Find out who is the founder of "Slytherin" House?
vi. Change the name of “Ginny Wasely” to “Ginny Potter”.
vii. Show the total scores of each house. Only include those houses that have total scores of more than 50.
