How to write nested query?

Question

I need to display the count of present status for a particular name

Select count(*) from employees where status='Present';

This query returns me entire present count. What should I do to get status for a particular name?

Answer 1

Try this:

select name, count(*)
  from employees
  where name = 'abc' and
        status = 'Present';

Share and enjoy.

Answer 2

select count(1) from employees where status='Present' group by name

Answer 3

Do you mean this?

select status, count(*)
from   employees
group by status

Or

select name, count(*)
from   employees
where status = 'Present'
group by name