Harry Potter Database

 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.