SELECT t.tid, t.tdate, p.productname, sv.quantity AS quantity_sold, (sv.quantity * p.productprice) AS amount_charged FROM salestransaction t JOIN soldvia sv ON t.tid = sv.tid JOIN product p ON sv.productid = p.productid ORDER BY t.tid