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, payment date and payment amount from the tables $$customer$\_$test$$ and $$payment$\_$test$.$ Where the records from latest payment to be on top $($first result$).$

Expected Result

payment$\_$amount customer$\_$last$\_$name payment$\_$date customer$\_$first$\_$name

$1250$ Smith $2005-12-20$ Peter

$1000$ Smith $2005-11-20$ PeterThe table here is just an example of how your answer is expected. You use this as a reference only!