DATE calculation in SQL is tricky. Sometimes you need to find Day name, Day of the week, and Next Day Date. These example SQL queries useful for you.
This post covers how to use WHERE and DELETE in sub-queries. Useful examples to refer to quickly.
I have explained how to format DATE by using views.
Simple ideas and quickly what you need to find to write a query for joining of two tables explained.