This is a Microsoft SQL tutorial that shows how SQL can be used without actually referencing tables. Using selects to return data to screen. Including variables, DATEADD and GETDATE.
Complimentary videos:
Date functions and getdate: • MS SQL tutorial on date functions