Questions: UNIT 3 - CHALLENGE 3.1: single Table Query Foundations 8 - Multiple Filters LEARNING OBJECTIVE: Compose a SELECT statement that uses AND and OR to combine filtering of conditions. For this question, use the PostgreSQL database for this course. Using the AND or OR Operator, filter the customer table for customers who have a gmail.com email address and live in the country Canada. What is the last name of the second record? a) Tremblay b) Silk c) Philips d) Peterson

To solve this problem, we need to construct a SQL query that filters the customer table for specific conditions: customers who have a Gmail email address and live in Canada. We will use the AND operator to combine these conditions.

Here's a step-by-step breakdown of how to approach this:

1. Understand the Requirements: We need to filter customers based on two conditions:

   • The email address should end with @gmail.com.
   • The country should be Canada.

2. Construct the SQL Query:

   • We will use the SELECT statement to retrieve data from the customer table.
   • The WHERE clause will be used to apply the filters.
   • The AND operator will combine the two conditions.

3. SQL Query: sql SELECT * FROM customer WHERE email LIKE '%@gmail.com' AND country = 'Canada';

4. Determine the Last Name of the Second Record:

   • Execute the query in the PostgreSQL database.
   • The result will be a list of customers who meet both conditions.
   • Identify the second record in the result set and note the last name.

5. Answer the Multiple-Choice Question:

   • Based on the execution of the query, identify the last name of the second record.

Since I cannot execute the query directly, I will provide an explanation for each option:

• a) Tremblay: This could be the correct answer if the second record in the result set has this last name.
• b) Silk: This could be the correct answer if the second record in the result set has this last name.
• c) Philips: This could be the correct answer if the second record in the result set has this last name.
• d) Peterson: This could be the correct answer if the second record in the result set has this last name.

To determine the correct answer, you would need to run the query in the PostgreSQL database and check the second record's last name.