12.f.   Get a list of classes, list by class ID and enrollment, in decreasing order of class enrollment, where enrollment is greater than 54.

 

Commands

Output

Select classes.class_id, enrollment

From classes

Where enrollment > 54

Order by enrollment desc;

CLASS_ID       ENROLLMENT

980-77855         85

333-97862         76

765-22290         68

661-56720         62

866-56721         58

998-77211         56

 

6 rows selected.