I am struck on this query. I don't understand the Yes/No value part. I thinks it is done using CASE.

Using the Northwind database write a query that returns all customers, and for each return a Yes/No value depending on whether the customer placed orders on December 12, 2020

This is what I got so far:

SELECT DISTINCT c.CustomerID, c.CompanyName, CASE WHEN OrderDate = '2020-12-12' THEN 'YES' ELSE 'NO' END FROM Orders JOIN Customers as c ON Orders.OrderID = c.CustomerID GROUP BY c.CustomerID

Desired output: n+1 ima ca 1=424y