Q6

0/1 points (graded)

Find names and grades of students who only have friends in the same grade. Return the result sorted by grade, then by name within each grade.

Note: Your queries are executed using SQLite, so you must conform to the SQL constructs supported by SQLite.

Codes Are Required.!

Highschooler \begin{tabular}{|c|l|l|} \hline \hline ID & \multicolumn{1}{|c|}{ name } & grade \\ \hline 1510 & Jordan & 9 \\ \hline 1689 & Gabriel & 9 \\ \hline 1381 & Tiffany & 9 \\ \hline 1709 & Cassandra & 9 \\ \hline 1101 & Haley & 10 \\ \hline 1782 & Andrew & 10 \\ \hline 1468 & Kris & 10 \\ \hline 1641 & Brittany & 10 \\ \hline 1247 & Alexis & 11 \\ \hline 1316 & Austin & 11 \\ \hline 1911 & Gabriel & 11 \\ \hline 1501 & Jessica & 11 \\ \hline 1304 & Jordan & 12 \\ \hline 1025 & John & 12 \\ \hline 1934 & Kyle & 12 \\ \hline 1661 & Logan & 12 \\ \hline \end{tabular} Likes \begin{tabular}{||l|l|} \hline ID1 & ID2 \\ \hline 1689 & 1709 \\ \hline 1709 & 1689 \\ \hline 1782 & 1709 \\ \hline 1911 & 1247 \\ \hline 1247 & 1468 \\ \hline 1641 & 1468 \\ \hline 1316 & 1304 \\ \hline 1501 & 1934 \\ \hline 1934 & 1501 \\ \hline 1025 & 1101 \\ \hline \end{tabular}