How do you do this in SQL? Query 2
Find all students () who have more than 50 credits and list alphabetically by name. Find how many faculty in the CSC department are professors. For each class (classid), show the number of students enrolled. This should be a two column table with well-labeled headings. Find all classes (classid) in which fewer than three students are enrolled. Find the Stuid’s of all students taking ART 103A. The result should be a two column table.