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.

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

类似问题

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.

更多留学生实用工具

智能学习助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单