I need query formats for these questions

\begin{tabular}{|l|l|} \hline Question 1 & What is the most common allergy for each marital status? \\ \hline Query (SQL) & \\ \hline Result & > \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline Question 2 & What is the number of patients in each different type of allergy? \\ \hline Query (SQL) & \\ \hline Result & > \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline Question 3 & How many patients have no records of allergy in their medical history? \\ \hline Query (SQL) & \\ \hline Result & > \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline Question 4 & Whatisthepercentageofpatients(0100%)thathaveNOTtakenanyimmunizationsyet? \\ \hline Query (SQL) & \\ \hline Result & > \\ \hline \end{tabular}