SQL and Query Editor

I'm trying to create a report using the Query Editor on Service Desk Plus. I'm trying to simply run a report that lists the computers which have approved Antivirus software installed. (I associated several software packages with a new software category called "Antivirus", SoftwareCategoryID 301) Also, I would like to run a report that shows all scanned computers that do not have approved Antivirus software installed.

On our SQL server I've built this query for the first part:

SELECT [WORKSTATIONNAME], [LOGGEDUSER], [SOFTWARECATEGORYID]

FROM [Zohoservicedesk].[dbo].[SoftwareCategory], [Zohoservicedesk].[dbo].[SystemInfo]

WHERE [Zohoservicedesk].[dbo].[SoftwareCategory].[SOFTWARECATEGORYID]=301

ORDER BY [WORKSTATIONNAME]

This runs just fine on the SQL server but it does not on the Query Editor.

Question 1: Why do you think that this doesn't run using the Query Editor?

Question 2: Is there an easier way to get these two reports that I'm missing?