I got stuck on the SQL question, the DBMS I am using is Oracle. the database is as follow:

The questions are:

1. Find the names of all the teachers that Ann Chin has, along with all her classes and grades from each.

2. For each student, find the number of classes he or she is enrolled in. Limit the results to only students who are enrolled.

University Sample Database Student Table stuld lastName firstName major 51001 Smith Tom History 51002 Chin Ann Math S1005 Perry History S1010 Burns Edward Art $1013 McCarthy Owen Math S1015 Jones Mary Math S1020 Rivera Jane CSC credits 90 36 3 63 rank Professor Instructor Assistant Associate Professor Lee 0 42 15 Faculty Table faced name department F101 Adams Art F105 Tanaka CSC F110 Byrne Math F115 Smith History F221 Smith CSC Enroll Table stuld class Number 51001 ART103A 51001 HST205A $1002 ART103A S1002 CSC201A $1002 MTH1030 S1010 ART103A S1010 MTH103C S1020 CSC201A S1020 MTH101B grade A C D room F B Class Table class Number facId ART103A F101 CSC2014 F105 CSC203A F105 HST205A F115 MTH101B F110 MTH103C F110 schedule MWF9 TuThF10 MThF12 MWF11 MTuTh9 MWF11 H221 M110 M110 H221 H225 H225 B A