Please helping me these three questions about SQL.

1. Write a SQL query to display a count of the total number of US Resident students and total number of Non-US Resident students.

2. Write a SQL query to display a count of the total number of students by State. The count should display as CountByState. Display the results in reverse alphabetical order by state.

3. Write a SQL query to display the total number of students for each MajorlD. Only display for those majors that have 40 or more students.

\begin{tabular}{|l|} \hline Course \\ \hline CourselD \\ Department \\ Coursetlumber \\ Description \\ Credits \\ MPCategory \\ Technical \\ \hline \end{tabular}