1. Show only the StudentID and the Maths_Score
2. Show records for students with ID numbers from BIT2016003 to BIT2016005
3. Add the sixth record with Student ID=BIT2016006, First name =Millicent, Surname = Duodu, Maths =64, French=56 and Programming=78.
4. Delete student whose ID = BIT2016004
5. Remove the surname column from the table

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