simpsons database (by Sylvia Tashev, Stefanie Hatcher)
students
| id | name | email |
|---|
| 123 | Bart | bart@fox.com |
| 456 | Milhouse | milhouse@fox.com |
| 888 | Lisa | lisa@fox.com |
| 404 | Ralph | ralph@fox.com |
teachers
| id | name |
|---|
| 1234 | Krabappel |
| 5678 | Hoover |
| 9012 | Stepp |
courses
| id | name | teacher_id |
|---|
| 10001 | Computer Science 142 | 1234 |
| 10002 | Computer Science 143 | 5678 |
| 10003 | Computer Science 190M | 9012 |
| 10004 | Informatics 100 | 1234 |
grades
| student_id | course_id | grade |
|---|
| 123 | 10001 | B- |
| 123 | 10002 | C |
| 456 | 10001 | B+ |
| 888 | 10002 | A+ |
| 888 | 10003 | A+ |
| 404 | 10004 | D+ |
to test queries on this database, use username homer, password d0ughnut