Question $4[25$ marks$]$

$($a$)$ Table $2$ shows the extracted information from $2021$ Best Teachers in Malaysia. Based on Table $2,$ write the SQL queries for the following requirements:

$\backslash$table$[[$ID$,$Ranking,School,Teacher,Rating Scale$],[1,9,$SJKC$,$Pang Chin Hoe,$2\mathrm{.}4],[2,2,$SK$,$Mahathir Alkhabur Bin Othman,$3\mathrm{.}7],[3,6,$SKJT$,$Saraswathi Murugam,$2\mathrm{.}9]]$

Table $2$

$($i$)$ List the Ranking and School in ascending order of Ranking.

$[4$ marks$]$

$($ii$)$ Calculate the average Rating$\_$Scale of all schools.

$[4$ marks$]$

$($iii$)$ Update the Rating$\_$Scale of all the schools by $5\%$ increment.

$[4$ marks$]$

$($b$)$ Provide the output of the following code:$($c$)$ MySQL is a widely used open$-$source relational database management system. Describe any THREE $(3)$ characteristics of MySQL$.[3$ marks$]$