Computer scienceFundamentalsSQL and DatabasesBasics SQLRetrieving Data

GROUP BY statement

Theory

Tutors and capacities

Report a typo

Write a grouping query for table tutors that for each tutor returns their name and minimum group capacity. Exclude minimums that equal to or below 30. Do not apply any ordering.

group_id tutor_name course capacity
12 Donald Meier Algebra 101 50
14 Becky Stout Nuclear Physics 101 25
22 Laura Gibbs Renaissance literature 360 30
36 Donald Meier Algebra 301 40
23 Becky Stout Information retrieval 450 30
38 Laura Gibbs Renaissance literature 360 40
Write an SQL statement





___

Create a free account to access the full topic