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...