I'm working on a query to get a list of all computers that have more than one antivirus installed. Unfortunately I'm unable to get my query to return anything. As you can see in the screenshots below I have setup the data so that it when I get the query working my result set will contain data on devices 1, 2, and 3.

![Devices Table](https://i.stack.imgur.com/OywZS.png)

![Antivirus Products Table](https://i.stack.imgur.com/ukbjW.png)

Here is what I've got currently:

```
SELECT d.ip_address AS "IP Address",
       d.name AS "Computer Name",
       av.name AS "Antivirus Name",
       COUNT(av.deviceID) AS "# of AV Installed"
FROM devices d JOIN anti_virus_products av
ON d.deviceID = av.deviceID
GROUP BY d.ip_address, d.name, av.name
HAVING COUNT(av.deviceID) > 1;

```