Table: customer$\_$test

customer$\_$id customer$\_$first$\_$name customer$\_$last$\_$name

$1$ Johnny Walker

$2$ Amber Rose

Table: account$\_$test

account$\_$id bill$\_$amount customer$\_$id

$1$ Corporate $1$

Table: payment$\_$test

payment$\_$id payment$\_$amount payment$\_$date account$\_$id

$11002005-05-101$

$21252005-06-201$

Table: bill$\_$test

bill$\_$id bill$\_$amount account$\_$id bill$\_$date

$110012005-05-10$

$212512005-06-10$

based on table above,Write a query to display first name, last name, total bill amount, and total payment amount from tables $$customer$\_$test$,$payment$\_$test$$ and $$bill$\_$test$.$ You are expected to use sql sum and group by functions.

Expected Result

total$\_$payment$\_$amount total$\_$bill$\_$amount customer$\_$last$\_$name customer$\_$first$\_$name

$255255$ Smith PeterThe table here is just an example of how your answer is expected. You use this as a reference only!