With Sales table the columns relevant to question are transaction_date and Product. The transaction_date column actually has the date and time of purchase in it. I need to write a query that shows all chairs purchased on 1/12/19. I have the below query, but it is not yielding any results.
SELECT *
FROM sales
WHERE product = 'chair'
AND Date(transaction_date) = '1/12/19'