This is my code:

import pandas as pd

import sqlite$3$

df $=$ pd$.$read$\_$csv$(\text{'}$Ten$\_$Students$\_$Grades.csv$\text{'})$

db $=$ sqlite$3.$connect$("$student$.$db$")$

cursor $=$ db$.$cursor$()$

query $=$ "CREATE TABLE IF NOT EXISTS Ten$\_$Students$($ID INT NOT NULL PRIMARY KEY, First$\_$name TEXT, Last$\_$name TEXT, Midterm REAL, Final REAL, Project$1$ REAL, Project$2$ REAL, Grade REAL, Letter$\_$Grade TEXT$)$;$"$

cursor.execute$($query$)$

print$($pd$.$read$\_$sql$(\text{'}$Select $*$ from Ten$\_$Students', db$))$

insert$\_$query$=\text{'}\text{'}\text{'}$ INSERT INTO Ten$\_$Students$($ID$,$ First$\_$name, Last$\_$name, Midterm, Final, Project$1,$ Project$2,$ Grade, Letter$\_$Grade$)$ values $(?,?,?,?,?,?,?,?,?)\text{'}\text{'}\text{'}$

db$.$close$()$

how do I:

$2-$ Write a query to insert all records by a single "INSERT" query.

$3-$ Write a query to order students by their names $($from A$-$ Z$)$

$4-$ Write a query to return number of students who received the same "Letter Grade"

$5-$ Write a query to delete all students with Letter$\_$Grade $="$D$".$