SQL query guidelines - DB name and field-name referencing

Is there a discussion or some examples of basic SQL queries which can be used as guideline to extract basic reports from DB as needed from time to time. For example I want a basic report to list all Listings with "Status = Active" and "Active till" date <= today's date

Hope someone can help with this