I am using this below and it is not pulling the count into the data extension created once automation is complete. Only SubscriberKey and EmailAddress pulls in to the data extension, once automation is complete. Any Assistance?
[SELECT count() AS TotalSent, SubscriberKey as EmailAddress, SubscriberKey FROM _Sent WHERE Domain LIKE '%site-dev.com%' AND EventDate between '2018-01-01' and CURRENT_TIMESTAMP GROUP BY SubscriberKey HAVING COUNT() > 0]