Repeating group is defined as

a$.$ SELECT tablelist FROM columnlist $[$WHERE conditionlist$][$ORDER BY columnlist $[$ASC $|$ DESC$]$:

b$.$ SELECT columnlist FROM tablelist $[$WHERE conditionlist$][$ORDER BY columnlist $[$ASC $|$ DESC$]$;

c$.$ SELECT tablelist FROM columnlist $[$ORDER BY columnlist $[$ASC $|$ DESC$][$WHERE conditionlist$]$;

d$.$ SELECT columnlist $[$WHERE conditionlist$]$ FROM tablelist $[$ORDER BY columnlist $[$ASC $|$ DESC$]$;