Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 AVGtotal FROM invoice WHERE billingcountry 'Canada' AND billingcountry 'USA'; b SELECT FROM invoice WHERE total SELECT AVGtotal FROM invoice WHERE billingcountry 'Canada' AND billingcountry 'USA'; c SELECT FROM invoice WHERE total SELECT AVGtotal FROM invoice WHERE billingcountry 'USA' AND billingcountry 'Canada'; d SELECT AVGtotal FROM invoice WHERE total SELECT FROM invoice WHERE billingcountry 'Canada' AND billingcountry 'USA';
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 AVGtotal FROM invoice
WHERE billingcountry 'Canada'
AND billingcountry 'USA';
b
SELECT FROM invoice
WHERE total
SELECT AVGtotal FROM invoice
WHERE billingcountry 'Canada'
AND billingcountry 'USA';
c
SELECT FROM invoice
WHERE total
SELECT AVGtotal FROM invoice
WHERE billingcountry 'USA'
AND billingcountry 'Canada';
d
SELECT AVGtotal FROM invoice
WHERE total
SELECT FROM invoice
WHERE billingcountry 'Canada'
AND billingcountry 'USA';
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started