Round3 linting

[smkordik78]

• Be consistent with table references - either all or none
• If multiple tables used in query, use table references to avoid ambiguity
• Allow subqueries in FROM or JOIN statements but not both, use Common Table Expressions (CTEs) as alternative
• If using DESC or ASC for any column, all columns should have a designation
• Use a consistent convention for casting CONVERT, CAST or ::
• Use fully qualified joins, e.g. INNER, LEFT, RIGHT, etc.
• ELSE NULL is redundant in a CASE statement, just use ELSE