| Title | Topics | Action | |||
|---|---|---|---|---|---|
| 26 | Department Codes and BuildingsReturn three columns for every department: `code`, `name` and `building`. There ... | easy | ○ Not Started | SELECT Basics | Solve |
| 27 | The Whole Courses TableShow every column of every course without typing out the column names. The `cour... | easy | ○ Not Started | SELECT Basics | Solve |
| 28 | Students Who Live in TorontoList the `first_name` and `last_name` of every student whose home `city` is Toro... | easy | ○ Not Started | SELECT Basics | Solve |
| 29 | Courses Not Worth Three CreditsMost courses are worth 3 credits. Return the `code`, `title` and `credits` of ev... | easy | ○ Not Started | SELECT Basics | Solve |
| 30 | Grades Below 60From `enrollments`, return `student_id`, `course_id` and `grade` for every row w... | easy | ○ Not Started | SELECT Basics | Solve |
| 31 | Instructors Paid at Least 90000Return `first_name`, `last_name` and `salary` for every instructor whose `salary... | easy | ○ Not Started | SELECT Basics | Solve |
| 32 | Students With No Declared MajorFour students have not chosen a major yet. Return their `first_name`, `last_name... | easy | ○ Not Started | SELECT Basics | Solve |
| 33 | Instructor Full NamesReturn one column called `full_name` holding each instructor's first and last na... | easy | ○ Not Started | SELECT Basics | Solve |
| 34 | Toronto or Ottawa but Not GraduatedReturn `first_name`, `last_name`, `city` and `status` for students who live in T... | medium | ○ Not Started | SELECT Basics | Solve |
| 35 | Course Titles Ending in -ingReturn the `code` and `title` of every course whose `title` ends with the letter... | medium | ○ Not Started | SELECT Basics | Solve |
| 36 | Lecturers and Assistant ProfessorsReturn `first_name`, `last_name` and `title` for every instructor whose `title` ... | medium | ○ Not Started | SELECT Basics | Solve |
| 37 | Best Five Grades of Fall 2024From `enrollments`, find the five highest grades among enrollments dated from `2... | medium | ○ Not Started | SELECT Basics | Solve |
| 38 | Second Page of Scholarship HoldersStudents whose `scholarship_amount` is NULL have no scholarship and must be left... | medium | ○ Not Started | SELECT Basics | Solve |
| 39 | Everyone Outside CS and MathReturn `first_name`, `last_name` and `major_department_id` for every student who... | hard | ○ Not Started | SELECT Basics | Solve |
| 40 | Letters of B or Better by CourseWhich letter grades of B or better has each course handed out? From `enrollments... | hard | ○ Not Started | SELECT Basics | Solve |
| 41 | Second-Floor Offices and Monthly PayOffice codes are a letter, a dash and a room number whose first digit is the flo... | hard | ○ Not Started | SELECT Basics | Solve |