Double check about stat query

[longfin]

https://planetariumhq.slack.com/archives/C03P5080KJL/p1660285618583749

# 일별 DAU 및 스테이지 플레이 액션 카운트 조회 쿼리 (Play&Sweep)
select DATE_FORMAT(`Timestamp`, '%Y-%m-%d'), COUNT(DISTINCT AgentAddress), count(*) from 
(select AgentAddress, `Timestamp` FROM HackAndSlashes WHERE `Timestamp` > '2022-05-14 00:00:00'
union
select AgentAddress, `Timestamp`FROM HackAndSlashSweeps WHERE `Timestamp` > '2022-05-14 00:00:00')
as a GROUP by DATE_FORMAT(`Timestamp`, '%Y-%m-%d')

# 일별 아레나 수행 계정 및 횟수 조회 쿼리
select DATE_FORMAT(`Timestamp`, '%Y-%m-%d'), COUNT(DISTINCT AgentAddress), count(*) from BattleArenas where `Timestamp` > '2022-05-14 00:00:00' GROUP by DATE_FORMAT(`Timestamp`, '%Y-%m-%d')  

# 일별 강화 수행 계정 및 횟수 조회 쿼리
select DATE_FORMAT(`Timestamp`, '%Y-%m-%d'), COUNT(DISTINCT AgentAddress), count(*) from ItemEnhancements where `Timestamp` > '2022-05-14 00:00:00' GROUP by DATE_FORMAT(`Timestamp`, '%Y-%m-%d')

#일간 거래량/거래금액/거래인원 집계 쿼리 (품목 통합)
select DATE_FORMAT(`Timestamp`, '%Y-%m-%d') as date, COUNT(OrderId), sum(price), COUNT(DISTINCT SellerAvatarAddress, BuyerAvatarAddress)  from (
(select OrderId , SellerAvatarAddress , BuyerAvatarAddress , Price, Timestamp from ShopHistoryConsumables WHERE `Timestamp` > '2022-05-14 00:00:00')
Union all 
(select OrderId , SellerAvatarAddress , BuyerAvatarAddress , Price, Timestamp  from ShopHistoryCostumes WHERE `Timestamp` > '2022-05-14 00:00:00')
Union all 
(select OrderId , SellerAvatarAddress , BuyerAvatarAddress , Price, Timestamp  from ShopHistoryEquipments WHERE `Timestamp` > '2022-05-14 00:00:00')
Union all 
(select OrderId , SellerAvatarAddress , BuyerAvatarAddress , Price, Timestamp  from ShopHistoryMaterials WHERE `Timestamp` > '2022-05-14 00:00:00')
) as a group by DATE_FORMAT(`Timestamp`, '%Y-%m-%d') ORDER BY DATE

# 일별 아레나 수행 계정 및 횟수 조회 쿼리
select DATE_FORMAT(`Timestamp`, '%Y-%m-%d'), COUNT(DISTINCT AgentAddress), count(*) from CombinationEquipments where `Timestamp` > '2022-05-14 00:00:00' GROUP by DATE_FORMAT(`Timestamp`, '%Y-%m-%d')  

# 일별 강화 수행 계정 및 횟수 조회 쿼리
select DATE_FORMAT(`Timestamp`, '%Y-%m-%d'), COUNT(DISTINCT AgentAddress), count(*) from CombinationConsumables where `Timestamp` > '2022-05-14 00:00:00' GROUP by DATE_FORMAT(`Timestamp`, '%Y-%m-%d')

[longfin]

제가 할 수 있는 차원의 검증은 했고, 용도는 위클리 리포트에 넣어 트렌드 보는 거니 긴급한 이슈는 아닙니다~ [천천히, 시간되실 때] 확인해 주시면 감사하겠습니다~

https://planetariumhq.slack.com/archives/C03P5080KJL/p1660296250252829?thread_ts=1660285618.583749&cid=C03P5080KJL