Quer related to Count Function

[tandon]

Hello ,
I am using below query to get count of all the data in column name = Call_Type
having value as either New or Repeat, plz help







SELECT sales.Region , sales.FLM , Count(sales.Call_Type) AS TotalCalls
FROM (SELECT DISTINCT Region, FLM, Call_Type FROM sales) AS TotalCalls
GROUP BY sales.Region, sales.FLM
ORDER BY sales.Region, sales.FLM;