Group by with order by error

Question

Hello,

 

My query is:

 

"select category ,sum(quantity) as qnty from BeautySupplyChannel

where BeautySupplyChannel.date>='2017/03/28' and BeautySupplyChannel.date<='2017/03/30' group by category order by BeautySupplyChannel.date"

 

But it shows error "Column "BeautySupplyChannel.Date" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause." 

 

Please help. Thanks