Query get customer statement

is there any examples to get customer statement

table design

Number Date Debit Credit Balance CustID

also how to get sum of numeric value * int value