How to do these two questions in SQL

1. Prepare a listing of all non-technical courses. Display all fields and sort on credit hours descending and then by department ascending.
2. Display all felds for a listing of all male students born after 1/1/1990 who are from Ohio"OH, Kentucky (KY, or Indiana (IN). Sort alphabeticaly by state then by last name.

\begin{tabular}{l} Class \\ \hline CiassiD \\ CourselD \\ Semester \\ Ciasssection \\ instructor \\ tocation \\ Time \\ MaxEnroliment \\ \hline \end{tabular} USResident State MajoriD 00 \begin{tabular}{l} Class \\ \hline CiassiD \\ CourselD \\ Semester \\ Ciasssection \\ instructor \\ tocation \\ Time \\ MaxEnroliment \\ \hline \end{tabular} USResident State MajoriD 00