sql query: Incorrect syntax near the keyword 'GROUP' : I am writing an sql query but keep getting syntax error: Incorrect syntax near the keyword 'GROUP'. What could be causing this issue? see query below:                                                                                                                                                                                                                                                                                                                                      










  