SQL Query please

1. Find the distinct instructors who taught a 'Cpts' course in the 'Spring' '2020' semester. Return the firstname, lastname, and title of those instructors. (Order by firstname.) firstname lastname | title Diane Sakire Venera (3 rows) | Cook | Professor | Arslanay | Associate Professor | Arnaoudova | Assistant Professor 2. Find the classes that have more than 10 students enrolled in them. Return the classid, major, courseNum of each class and the number of students enrolled. (Order by major and coursenum.) classid | major | coursenum | numstudents 2019301 Cpt8437 | Cpts | 437 2019301 Cpt 3451 | Cpts | 451 1 14 2019F02STAT360 | STAT | 360 12 (3 rows) 14 3. Find the courses which do not have any prerequisites. Return the major, courseNum, and title of each such course. (Order by major and coursenum.) major | coursenum title Cpts 132 Cpts | 223 Cpts | 581 Cpts | 582 MATH | 171 | Data Structures - Java | Advanced Data Structures | Software Maintenance | Software Testing | Calculus