Revisions to Count and group SQL Server table data

added 10 characters in body

Source Link

edited Jun 18, 2020 at 14:32

You can use aggregation:

select name, count(*), sum(error) as error, sum(success1 - error) as success
from attempts
group by name;

If you want the success rate, you can use:

avg( 1.0 - error ) as success_rate

You can use aggregation:

select name, count(*), sum(error) as error, sum(success) as success
from attempts
group by name;

You can use aggregation:

select name, count(*), sum(error) as error, sum(1 - error) as success
from attempts
group by name;

If you want the success rate, you can use:

avg( 1.0 - error ) as success_rate

An *almost* unfortunate typo

Source Link

edited Jun 18, 2020 at 14:31

Thom A ♦

You can use aggregation:

select name, contcount(*), sum(error) as error, sum(success) as success
from attempts
group by name;

You can use aggregation:

select name, cont(*), sum(error) as error, sum(success) as success
from attempts
group by name;

You can use aggregation:

select name, count(*), sum(error) as error, sum(success) as success
from attempts
group by name;

Source Link

answered Jun 18, 2020 at 14:30

Gordon Linoff

You can use aggregation:

select name, cont(*), sum(error) as error, sum(success) as success
from attempts
group by name;

Return to Answer