Problem

Given a table of customer's first and last names, write a query to find all customers whose first name is "John" and last name is "Smith".
Example input:
First_Name | Last_Name
-----------|-----------
John       | Smith
Mike       | Smith
John       | Doe
Example output:
First_Name | Last_Name
-----------|-----------
John       | Smith

Solution

SELECT First_Name, Last_Name
FROM Customers
WHERE First_Name = 'John' AND Last_Name = 'Smith';

/*

The solution above is optimal because it uses the WHERE clause to filter the results to only include customers with the first name "John" and the last name "Smith".

*/