Using mySQL i have 3 tables.

table 1: students id (primary key) first last

table 2: quizzes id (primary key) number chapter points

table 3: takenQuizzes id (primary key) quiz$id (foreign key for quizzes table) student$id(foreign key for students table) score

What i have to do: 1) List the quiz `chapter`, student `first`, `last` and `score` ordered by `chapter` and decreasing `score`. 2) List the student name (`last`, `first`) as the column **Student** and quiz `number` as the column **Quiz** of all taken quizzes, order by **Quiz** then **Student**. 3) List the student `first`, `last`, quiz `number` as the column **quiz**, `points`, raw `score` and score as a percentage of total points as the column **percent**. Format the percent to 2 decimals, e.g. **0.75**. Order by `number` then in descending order by **percent**. 4) Update the score *John Doe* earned on their third quiz to a *10*. 5) Delete all quizzes taken during **10/01** and **10/09**.