Which statements will be able to show the following result set?

a$.)$

SELECT invoice$\_$id$,$ total, last$\_$name

FROM invoice

JOIN customer

USING $($invoice$.$customer$\_$id $=$ customer.customer$\_$id$)$;

b$.)$

SELECT invoice$\_$id$,$ total, last$\_$name

FROM invoice, customer;

c$.)$

SELECT invoice$\_$id$,$ total, last$\_$name

FROM invoice

JOIN customer

USING $($customer$\_$id$)$;

d$.)$

SELECT invoice$\_$id$,$ total, last$\_$name

FROM invoice

WHERE customer$\_$id $!=$ NULL;

SUBMIT MY ANSWER

Answer rating: 100% (QA)

The question seems to want the correct SQL query to select three columns invoiceid total and lastnam... View the full answer