1.sqluername = "select mode, d.name_drug, sum(quantity) as total_quantity, sum(quantity_sale) as total_quantity_sale "
2. sqluername &= "FROM drug d INNER JOIN mode m ON d.id_mode = m.id_mode "
3. sqluername &= "GROUP BY d.name_drug, mode HAVING (sum(quantity) <= sum(quantity_sale))"
