SQL

Student Faculty Stuld lastName firstName major credits facID name department rankk ArtProfessor Instructor S1001 S1002 S1005 S1010 S1013 S1015 SmithTom History F101 F105T F110 F115 F221 Chin Math Tanaka 36 63 0 Ann HistoryAssociate Professor Burns Edward Art Smith McCarthy Owen Math Mary Math Jones S1020 Enroll Class Stuld ClassNumbergrade ART103A HST205A S1001 S1002 S1002 S1002 classNumber facld schedule room ART103A CSC201A F105 TuThF10 M110 CSC203A HST205A MTH101B CSC201A F105 MIhF12 F115 MWF11 H221 $1010 ART103A S1010 S1020 S1020 MTH103C CSC201A 103C F110 MWF11 H225 MTH101B A Find and show by classNumber all courses in which fewer than three students are enrolled 3. Find the number of courses taught by each instructor, giving.e the instructors name and the number of courses they have taught