Get familiar with SQLite commands, and work with CSV files.
Import data from files, learn how to merge data from different tables, and study how to use various SQL commands.
A hacker has attacked the IT system of your school and destroyed the database. As a leader of the Science Club,
your school has asked for your help. The situation is grave. There is only one week before the final annual exams.
You need to recover the annual scores of the students. The school management provides the data from the archive,
and the Science Club members help you with csv files.
Your task is to create the school database and calculate the annual score.
Create your first table that contains teachers and students.
Find out who the students are.
You listed the students. Time to create the student table.
Your friends created score files for you. Merge the scores and display them.
You listed the scores, now create the score table.
Find out the grade code of the students and update the student table.
For last-year students, calculate the annual scores and display them.