hi frnds how to count my order according to date
select a.ClientId,a.ClientName,a.ClientStreet+','+a.ClientApt+','+a.ClientCity+', '+a.ClientState+','+a.ClientPostal+', '
+a.ClientCountry as adres,
b.orderNumber, b.date[Order Date],c.ProductCode+' '+c.ProductName as ProductName,c.Image1,d.individual_price,d.individual_shipping,e.transaction_numbr,e.transaction_status,e.admin_ka_status ,e.transactionId ,d.Qantity
from dbo.Tbl_Client_Address a inner join dbo.Tbl_OrderMaster b on a.ClientId=b.ClientAdrsId
inner join dbo.Tbl_OrderDetail d on b.orderId=d.OrderMasterfkId inner join dbo.Tbl_Products c on
d.ProductFkId=c.ProductId inner join dbo.Tbl_TransactionStatus e on e.client_loginId=a.Client_detail_id
and b.orderId=e.order_ki_Id where e.admin_ka_status='open'