Suppose you have a database containing the following two sma…
Suppose you have a database containing the following two small tables: table name: customers customer_id customer_name membership 1 Bob basic 2 Larry basic 3 Judy elite 4 Doug elite 5 Rachel basic table name: transactions, transaction_id customer_id transaction_date transaction_amount 1 3 ‘2018-04-01’ 478.02 2 3 ‘2018-05-15’ 15.11 3 4 ‘2018-06-01’ 167.89 4 4 ‘2018-06-01’ 1004.21 5 4 ‘2018-07-04’ 452.52 6 1 ‘2018-08-21’ 19.01 Which of the following SQL queries returns the output below (Make sure the column names match the above table as well): customer_id transaction_id customer_name transaction_date transaction_amount 3 1 Judy ‘2018-04-01’ 478.02 4 3 Doug ‘2018-05-01’ 167.89 4 4 Doug ‘2018-06-01’ 1004.21 4 5 Doug ‘2018-07-04’ 452.52