how sum "Total" in php mysql

how to sum Total ?

Syntax

$data = mysqli_query($conn,"SELECT B.name_store , A.name, A.price,C.qty,(A.price * C.qty) as total, From product A,store B,dtl_transaksi C
where C.id_store=B.id_store AND C.id_product=A.id ");

Result: image