SELECT tbl_barangay.barangay_name,
   tbl_transaction_details.supplier_medicine_id,
   tbl_supplier_medicine.medicine_name,
   SUM(tbl_transaction_details.total_price) as 'Total'
  FROM
   tbl_transaction_details
  INNER JOIN
   tbl_supplier_medicine ON tbl_transaction_details.supplier_medicine_id =
   tbl_supplier_medicine.supplier_medicine_id
  INNER JOIN
   tbl_transaction ON tbl_transaction.transaction_id =
   tbl_transaction_details.transaction_id
  INNER JOIN
   tbl_barangay ON tbl_barangay.barangay_id = tbl_transaction.barangay_id
  WHERE
   tbl_barangay.barangay_id = 1
  AND
   tbl_transaction.transaction_date BETWEEN "2019-08-18" AND "2019-08-18"
  GROUP BY
   tbl_transaction_details.supplier_medicine_id