calculating unique views based on ip, session_id

[Cam Bazz]

Hello,

So I have table of item views with item_sid, ip_number, session_id

I know it will not be that exact, but I want to get unique views per
item, and i will accept ip_number, session_id tuple as an unique view.

when I want to query just item hits I say: select item_sid, count(*)
from item_raw group by item_sid;

but if I say:

select item_sid, count(*) from item_raw group by item_sid, ip_number,
session_id;

it will give me duplicate item sids.

how can I query per unique tuple of ip_number, session_id per item_sid?

best regards,
c.b.