คิดว่าไม่น่าพลาด... ฮ่าๆๆๆ
select t3.kind_name as product,sum(qsell) as quantity , sum(qsell*pricetotal) as gtotal
from stock_sell t1, stock_kind t2 , stock_kind_type t3
where t1.kindtypeid = t2.kindtypeid and t2.kindid = t3.kindid
group by t1.kindid
order by t1.datesell desc