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