学习sql语句

一直都不太会sql 语句

好麻烦好繁琐的逻辑

下面是我模仿别人写的sql语句

1. 业务逻辑是需要联合三张表查询，

select RESERVE_STORE_ID STORE_ID ,SKU_ID , sum(1) NUM ,DATA_TIME from 
( select o.RESERVE_STORE_ID  ,i.STATUS_ID,i.SKU_ID, convert(varchar(12),i.MODIFY_DATETIME,102) as DATA_TIME 
from TBL_RESERVE_ORDER_ITEM i 
left join TBL_RESERVE_ORDER o on o.ORDER_ID = i.ORDER_ID  
left join TBL_STARBUCKS_STORE s on o.RESERVE_STORE_ID = s.STORE_ID 
where i.STATUS_ID in ('2','6') and STORE_ID  is not null ) t 
group by t.RESERVE_STORE_ID ,t.SKU_ID ,t.DATA_TIME order by t.RESERVE_STORE_ID ,SKU_ID,t.DATA_TIME

2.

select RESERVE_STORE_ID STORE_ID ,SKU_ID ,sum(1) NUM ,RESERVE_DATETIME DATA_TIME from 
( select o.RESERVE_STORE_ID  ,o.RESERVE_DATETIME,i.STATUS_ID,i.SKU_ID, i.MODIFY_DATETIME 
from TBL_RESERVE_ORDER_ITEM i 
left join TBL_RESERVE_ORDER o on o.ORDER_ID = i.ORDER_ID  
left join TBL_STARBUCKS_STORE s on o.RESERVE_STORE_ID = s.STORE_ID 
where o.RESERVE_DATETIME is not null) t 
group by t.RESERVE_STORE_ID ,t.SKU_ID ,t.RESERVE_DATETIME order by t.RESERVE_STORE_ID ,SKU_ID,DATA_TIME