Using the toyu database (which is provided separately), write the SQL query for the following data problem. List the name of students with a grade A in any class. | f Name | I Name 1 | Tony | Hawk | Larry | Johnson | Lillian | Johnson | + To University (toyu) relations toyu.class: 14 rows total (approximately) classid courseld semester year facid room 10,000 2,000 Fall 2,019 1,011 D241 10,001 2,001 Fall 2,019 1,011 D242 10,002 2,002 Fall 2,019 1,012 D136 10,003 2,020 Fall 2,019 1,014 D241 10,004 2,021 Fall 2,019 1,014 D241 10,005 2,040 Fall 2,019 1,015 D237 10,006 2,041 Fall 2,019 1,019 D217 10,007 2,060 Fall 2,019 1,020 B101 10,008 2,080 Fall 2,019 1,018 D241 11,000 2,000 Spring 2,020 1,011 D241 11,001 2,001 Spring 2,020 1,013 D242 11,002 2,002 Spring 2,020 1,013 D136 11,003 2,020 Spring 2,020 1,016 D217 11,004 2,061 Spring 2,020 1,018 B101 toyu.course: 11 rows total (approximately) courseId rubric number name 2,000 CSCI 3333 Data Structures 2,001 CSCI 4333 Design of Dat... 2,002 CSCI 5333 DBMS 2,020 CINF 3321 Introduction t... 2,021 CINE 4320 Web Applicati... 2,040 ITEC 3335 Database Dev... 2,041 ITEC 3312 Introduction t... 2,060 ENGL 1410 English I 2,061 ENGL 1311 English II 2,080 ARTS 3311 Hindu Arts 2,090 ACCT 3333 Managerial Ac... credits 3 3 3 3 3 3 3 4 3 toyu.department: 7 rows total (approximately) deptCode deptName schoolCode numFaculty ACCT Accounting BUS 10 ARTS Arts HSH 5 CINE Computer Inf... CSE 5 CSCI Computer Sci... CSE 12 ENGL English HSH 12 ITEC Information T... CSE 4 MATH Mathematics CSE 7 toyu.school: 4 rows total (approximately) schoolCodeschoolName BUS Business EDU Education HSH Human Sciences and Humanities CSE Science and Engineering Next toyu.faculty: 11 rows total (approximately) facid fname Iname 1,011 Paul Smith 1,012 Mary Tran 1,013 David Love 1,014 Sharon Mannes 1,015 Daniel Kim 1,016 Andrew Byre 1,017 Deborah Gump 1,018 Art Allister 1,019 Benjamin Yu 1,020 Katrina Bajaj 1,021 Jorginlo Neymar deptCode rank CSCI Professor CSCI Associate Professor CSCI (NULL) CSCI Assistant Professor CINF Professor CINF Associate Professor ITEC Professor ARTS Assistant Professor ITEC Lecturer ENGL Lecturer ACCT Assistant Professor Next KNS toyu.student: 10 rows total (approximately) stuld fname Iname 100,000 Tony Hawk 100,001 Mary Hawk 100,002 David Hawk 100,003 Catherine Lim 100,004 Larry Johnson 100,005 Linda Johnson 100,006 Lillian Johnson 100,007 Ben Zico 100,008 Bill Ching 100,009 Linda King major CSCI CSCI CSCI ITEC ITEC CINE CINF (NULL) ARTS ARTS minor CINF CINF ITEC CINF (NULL) ENGL ITEC (NULL) ENGL CSCI credits 40 35 66 20 66 13 18 16 90 125 advisor 1,011 1,011 1,011 1,017 1,017 1,015 1,015 (NULL) 1,018 1,018 To University (toyu) relations n_alerts 0 (NULL) 2 0 1 2 0 toyu.enroll: 22 rows total (approximately) stuld classid grade 100,000 10,000 A 100,001 10,000 (NULL) 100,002 10,000 B- 100,000 10,001 A 100,001 10,001 A- 100,000 10,002 B+ 100,002 10,002 B+ 100,000 10,003 C 100,002 10,003 D 100,004 10,003 A 100,005 10,003 (NULL) 100,000 10,004 A- 100,004 10,004 B+ 100,005 10,004 A- 100,006 10,004 C+ 100,005 10,005 A- 100,006 10,005 A 100,005 10,006 B+ 100,007 10,007 F toyu.grade: 13 rows total (approximately) grade gradePoint A 4.0000 A- 3.6667 B 3.0000 B- 2.6667 B+ 3.3333 2.0000 C- 1.6667 C+ 2.3333 D 1.0000 0.6667 D+ 1.3333 F 0.0000 WX (NULL) D- 4 0 (NULL) 1 (NULL) 0 (NULL) 0 (NULL) (NULL) 4 100,006 100,005 100,007 100,008 100,007 100,000 10,005 A 10,006 B+ 10,007 F 10,007 C- 10,008 A- 11,001 D (NULL) (NULL) 4 0 0 4 Foreign keys
