Which of the following queries will use a subquery to find the rows in the invoice table in the country USA that have the invoice total larger than the average of invoices of those in the country Canada?

a$.)$

SELECT $*$ FROM invoice

WHERE total $>$

$($SELECT AVG$($total$)$ FROM invoice

WHERE billing$\_$country $=$ 'Canada'$)$

AND billing$\_$country $=$ 'USA';

b$.)$

SELECT $*$ FROM invoice

WHERE total $>$

SELECT AVG$($total$)$ FROM invoice

WHERE billing$\_$country $=$ 'Canada'

AND billing$\_$country $=$ 'USA';

c$.)$

SELECT $*$ FROM invoice

WHERE total $>$

$($SELECT AVG$($total$)$ FROM invoice

WHERE billing$\_$country $=$ 'USA'$)$

AND billing$\_$country $=$ 'Canada';

d$.)$

SELECT AVG$($total$)$ FROM invoice

WHERE total $>$

$($SELECT $*$ FROM invoice

WHERE billing$\_$country $=$ 'Canada'$)$

AND billing$\_$country $=$ 'USA';