1. You need to check your server logs. You can get it from here.
  2. In your server log, if you find any GROUP BY error, then please set sql_mode to the empty string.
  3. Execute below command in workbench: 

    SET sql_mode = ''

  4. This will resolve your issue.
  5. If you are still facing this issue, reach out to QMetry Support.