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. |