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$

Problem

Write a query to display the first name and last name of the records in table $$customer$\_$test$.$

Expected Result

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

Peter Smith

Amber WalkerThe table here is just an example of how your answer is expected. You use this as a reference only!