I have the following query to return the number of jobs(visits) that a customer availed and the distinct vets he/she has used.

```
SELECT 
customer.users_id AS CustID, 
COUNT(VisitID) AS Jobs, 
COUNT(DISTINCT VetID) AS Resources 
FROM customer 
LEFT JOIN visit ON customer.users_id = visit.CustID 
GROUP BY customer.users_id

```

When I add a WHERE clause to get count only visits that weren't Rescheduled or Cancelled, my query looks like this.

```
SELECT 
customer.users_id AS CustID, 
COUNT(VisitID) AS Jobs, 
COUNT(DISTINCT VetID) AS Resources 
FROM customer LEFT JOIN visit ON customer.users_id = visit.CustID 
WHERE visit.Status != 'Cancelled' AND visit.Status != 'ReScheduled' 
GROUP BY customer.users_id

```

However, in this case, I only get the customers who didn't have any cancelled or rescheduled visits, eben though I'm using a left join for customers.

How do I fit in the WHERE clause on this?