SQL Query having where clause in count

try...

select c.yourfield,
sum(case when C.RegistrationNumber is null or C.RegistrationNumber =  '' then 1 else 0 end) yourCnt
from yourTable C
Group by c.yourfield

Select allOpen in new window

This query just returns 1,0 ,need to have sum of the returned records.

The query is
Return employees who have more than 1 car  
Include a column that gives the number of cars they have registered


Cheers

how's your data looks like and what's your expected output?

try:

select c.yourfield,
count(C.RegistrationNumber) yourCnt
from yourTable C
where C.RegistrationNumber is not null and C.RegistrationNumber <> ''
Group by c.yourfield

Select allOpen in new window

Cheers mate wiil try and get back !

This query is errored

select E.EmployeeID,E.Firstname
count(C.RegistrationNumber) Number_of_Cars_Registered FROM
B35_Employees E  INNER JOIN B35_Cars C
       ON E.EmployeeID = C.EmployeeID
WHERE COALESCE(C.RegistrationNumber, '') <> ''
Group by C.EmployeeID

For example..

Select athlete, year, Sum(annual salary)
FROM league_stats
GROUP BY athlete, year
HAVING Sum(AnnualSalary) > 1000000   -- that made over a million bucks in their careers

Cheers Experts!