Given the following table definition, which query would retrieve unique customer IDs who have placed orders in the year 2025?
CREATE TABLE Orders (
OrderID INT PRIMARY KEY,
CustomerID INT,
OrderDate DATE
);

Question

Given the following table definition, which query would retrieve unique customer IDs who have placed orders in the year 2025? 
 CREATE TABLE Orders ( 
          OrderID INT PRIMARY KEY, 
          CustomerID INT, 
          OrderDate DATE 
 );

Accepted Answer

SELECT DISTINCT CustomerID FROM Orders WHERE YEAR(OrderDate) = 2025

Answer

SELECT DISTINCT CustomerID FROM Orders WHERE OrderDate >= '2025-01-01';

Answer

SELECT CustomerID FROM Orders WHERE OrderDate LIKE '2025%';

Answer

SELECT CustomerID FROM Orders GROUP BY OrderDate;

Crowdly

Given the following table definition, which query would retrieve unique customer...

Want instant access to all verified answers on eclass.yorku.ca?