SQL Basics - Challenge 1 -- Create a list of mailing information for orders that took place on April 20th, 2017.

I found this question too open-ended, but it forced me to be creative.

Q: -- Create a list of mailing information for orders that took place on April 20th, 2017.

My Logic:

select * from sales where sale_date = "2017-04-20"; --Returned nothing...

select * from sales where sale_date != "2017-04-20"; --Returned data, including 2017-4-20

select * from sales where sale_date = "2017-4-20"; -- Returned sales from customers on the requested date.

select * from sales, customers where sales.id = customers.id and sales.sale_date = "2017-4-20"; -- This will give me all the data for the return above. Now filter for ONLY mailing data, which would need the name of the recipient to address the mail.

select first_name, last_name, delivery_address from sales, customers where sales.id = customers.id and sales.sale_date = "2017-4-20"; -- Solution.

Am I answering the wrong thing with my queries? The solution provided was simple, but I felt that in real-world applications, that little data wouldn't suffice, hence the deeper dive.