MySQL COUNT based on a condition
You'll need a case expression to count the occurrences of 'Replaced':

select 
 item_name, 
 count(*), 
 count(case when item_replaced = 'Replaced' then 1 end)
from your_table
group by item_name