WITH CTE(ID_NUMBER ) as
(
select distinct O.ID_NUMBER ID_NUMBER  from Table as O
WHERE (O.FIRST_DATE BETWEEN '20090101' AND '20091231') 
)
select ID_NUMBER , count(ID_NUMBER)  R_Count from CTE
GROUP BY ID_NUMBER

select O.ID_NUMBER , count(O.ID_NUMBER) R_Count from Table as O
WHERE (O.FIRST_DATE BETWEEN '20090101' AND '20091231')
GROUP BY O.ID_NUMBER 

Select NIN_CODE,Count(*) as Cnt from (
select distinct OO.ORDER_NUMBER, OO.NIN_CODE
from Table as OO 
WHERE (OO.SUBMITTED_DATE BETWEEN '20090101' AND '20091231') 
AND (OO.TICKET_NUMBER IS NOT NULL) and OO.NIN_CODE='990685711' or OO.NIN_CODE='993435940'
) Main
group by NIN_CODE

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

You can check my BLOG here