I am trying to group the number of times a subscriber has visited each unique store but am getting an error:

    select subscriberkey, storename, count (orderID) as shopvisits from salesorder 
    group by subscriberkey,storename

What is missing from/incorrect about this query?

Thanks

I am trying to group the number of times a subscriber has visited each unique store but am getting an error:

select subscriberkey, storename, count (orderID) as shopvisits from salesorder 
   group by subscriberkey,storename

What is missing from/incorrect about this query?

Thanks

I am trying to group the number of times a subscriber has visited each unique store but am getting an error:

select subscriberkey, storename, count (orderID) as shopvisits from salesorder group by subscriberkey,storename

What is missing from/incorrect about this query?

Thanks

I am trying to group the number of times a subscriber has visited each unique store but am getting an error:

    select subscriberkey, storename, count (orderID) as shopvisits from salesorder 
    group by subscriberkey,storename

What is missing from/incorrect about this query?

Thanks