Database small white want to ask a problem sets, (have student achievement course selection table, as shown in figure use case then statements output each student's course gate number belongs to which interval/not a door, 1-3 door, 4-6, 7 above the door,), write not to come out, refer to correct me, thank you

CodePudding user response:
select student number, count (*) as course gate number, - the count (*) after the as to add Spaces, behind don't number=
The case when...
End as the column, the last name given to individual
The from CJB
CodePudding user response:
Ok, thank you