SELECT DISTINCT (SELECT NAME
                 FROM   users.company
                 WHERE  companyid = EMAR.ratedcompanyid
                        AND eventid = 8)                      AS [COMPANY_NAME],
                (SELECT TOP 1 Round(Avg(Cast(answervalue AS FLOAT))
                                      OVER(), 2) AS
                              [AVERAGE_GRADE_FOR_SINGLE_MEETINGS]
                 FROM   events.eventmeetingratinganswer
                 WHERE  staticratingquestionid = 1
                        AND answervalue != 'none'
                        AND eventmeetingagendaratingid IN
                            (SELECT eventmeetingagendaratingid
                             FROM   events.eventmeetingagendarating
                             WHERE  eventid = 8
                                    AND ratedcompanyid =
                                        EMAR.ratedcompanyid)) AS
                [SINGLE_MEETINGS_OVERAL_RATING]
FROM   events.eventmeetingratinganswer EMRA
       INNER JOIN events.eventmeetingagendarating EMAR
               ON EMRA.eventmeetingagendaratingid =
                  EMAR.eventmeetingagendaratingid
WHERE  EMRA.staticratingquestionid = 1
       AND EMRA.answervalue != 'none'
       AND EMAR.eventid = 8
ORDER  BY [single_meetings_overal_rating] DESC,
          [company_name] ASC