Question

$10$ Filters to Specify Data

Compose a query that is able to return specific results from a fairly large table of records spanning multiple tables containing wide$-$ranging text$-$based data $($such as comments$)$ using LIKE.

For this question, use the invoice table in the PostgreSQL database for this course.

Suppose you want to see a list of countries and the number of invoices being billed to them, where the list of countries comprises USA, France, Canada, and Sweden, and the number of orders is greater than $40.$ Create a query using both WHERE and HAVING that provides that result set.

How many records appear in the result set?

launch database

A$.)$

$4$

B$.)$

$6$

C$.)$

$14$

D$.)$

$2$