Which of the following SQL queries will list only the Full Names of all Customers who made Purchases on 2019-04-02?

Question

BlackTom AI · Accepted Answer

We start by restating the problem in our own words and then evaluate each option.

Option 1:
SELECT *
FROM Customer INNER JOIN Purchase
  on Customer.CustID = Purchase.CustID;
This query selects all columns from the joined Customer and Purchase tables for every matching row. It does not filter by a specific PurchaseDate, so it will list all purchases across all dates, and will also include many columns beyond Just GivenName and FamilyName. Therefore, it does not meet the requirement of listing only the Full Names for purchases made on a specific date.

Option 2:
SELECT GivenName,FamilyName
FROM Customer INNER JOIN Purchase
  on Customer.CustID = Purchase.CustIDWHERE PurchaseDate = '2019-04-02';
This option almost gets the right idea, selecting GivenName and FamilyName after joining. However, there is a syntax error: there is no space between the JOIN condition and the WHERE clause, causing the query to be invalid SQL in most dialects. Even if fixed, you would also need to ensure there is a newline or space before WHERE for readability, but the core issue is the missing space before WHERE, making it unusable as written.

Option 3:
SELECT * FROM Customer AND Purchase
WHERE PurchaseDate LIKE '2019-04-02';
This syntax is incorrect for joining tables. Using AND between table names is not valid; there is no FROM clause that lists both tables in a join, and referring to PurchaseDate with LIKE is unnecessary since an exact date comparison is preferred. Overall, this fails both structurally and semantically for the intended result.

Option 4:
SELECT GivenName,FamilyName
FROM Customer INNER JOIN Purchase
  on Customer.CustID = Purchase.CustID
WHERE PurchaseDate = '2019-04-02';
This option correctly joins the Customer and Purchase tables on the CustID, selects only the Desired columns GivenName and FamilyName, and applies a WHERE clause to filter rows where PurchaseDate matches '2019-04-02'. It returns the full names of customers who made purchases on that specific date and avoids extraneous columns. The usage of an inner join ensures only customers with purchases on that date are included, which aligns with the requirement.

Summary of why the options differ:
- Option 1 fetches all columns for all dates, not restricted to 2019-04-02.
- Option 2 attempts to filter by date but has a syntax issue near the WHERE clause, and even if corrected, could be prone to formatting issues.
- Option 3 uses an invalid join syntax and an inappropriate LIKE operator for an exact date check.
- Option 4 has the correct join, selects only the needed name columns, and applies the correct date filter to yield the requested result.

4510_COMP_SCI_X_0019 Quiz 4

Which of the following SQL queries will list only the Full Names of all Customers who made Purchases on 2019-04-02?

View Explanation

Log in for full answers

Similar Questions

Creating an "Outer Join" in Access will produce ONLY Null Values.

The default join type in Access is the outer join.

Below are the Movies and Sales table of a relational database: Dexter has created the following SQL query: SELECT tblMovies.Title, tblMovies.Genre, tblSales.CopiesFROM tblMovies, tblSalesWHERE tblMovies.MovieID = tblSales.MovieID How many records will be returned by the query?

Refer to the tables. Which query produces the result table below?

Creating an "Outer Join" in Access will produce ONLY Null Values.

The default join type in Access is the outer join.

More Practical Tools for Students Powered by AI Study Helper

Homework AI Solver

Stylized AI Paper Writer

Plagiarism Checker Assistant

Citation AI Academic Writing Tool

In-Class Translation Assistant

AI Note Generator

AI Quiz Answers

Past Exam Questions from University Test Bank

Smart Practice Assistant

Adaptive Practice

Making Your Study Simpler