Consider the Students table below populated with some information. Write appropriate SQL command to:

i. Display the SQL version installed on your computer

ii. Create a database named MyFirstSchool

iii. Create the table above and populate it with the data shown.

iv. Show all the information in the table

v. Show only the StudentID and the Maths_Score

vi. Show records for students with ID numbers from BIT2016003 to BIT2016005

vii. Add the sixth record with Student ID=BIT2016006, First name =Millicent, Surname = Duodu, Maths =64, French=56 and Programming=78.

viii. Delete student whose ID = BIT2016004

ix. Remove the surname column from the table

x. Change the French score to 69 for Student ID = BIT2016002

xi. Remove the Student table from the database

Database Design and Management 2 (Mode Protg) - Word (chec de l'activation du produit) Rfrences Publipostage Rvision Affichage Dites-nous ce que vous voulez faire Cration Disposition Conne ichiers provenant d'un emplacement Internet, car ils peuvent contenir des virus. Il est recommand de garder le mode protg sauf si vous devez effectuer des modifications Activer la mo Consider the Students table below populated with some information. StudentID Firstname BIT2016001 Cynthia BIT2016002 Victoria BIT2016003 Joseph BIT2016004 Paul BIT2016005 Ernest Surname Thompson Kumah Ayirebi Debrah Boabeng Maths_Score French_Score Programming_Score 76 80 82 71 69 59 76 73 60 69 52 72 48 84 65 Write appropriate SQL command to: I i. ii. iii. iv. V. vi. vii. Display the SQL version installed on your computer Create a database named MyFirstSchool Create the table above and populate it with the data shown. Show all the information in the table Show only the Student ID and the Maths_Score Show records for students with ID numbers from BIT2016003 to BIT2016005 Add the sixth record with Student ID=BIT2016006, First name =Millicent, Surname =Duodu, Maths =64, French=56 and Programming=78. Delete student whose ID = BIT2016004 Remove the surname column from the table Change the French score to 69 for Student ID = BIT2016002 Remove the Student table from the database viii. ix. X. xi