weekends, date math and weeks date math ISO standard WHERE clause capabilities of columns, restricting access compared to HAVING clause conditions components of equality/inequality matching membership range evaluation conditions GROUP BY clause HAVING clause and join conditions logical operators noncorrelated subqueries NULL expression partition pruning SELECT statements subqueries tips for using UPDATE statement and value of WIDTH_BUCKET analytic function wildcards ANY IS ANY windowing analytic functions WITH CHECK OPTION hiding columns WITH clause, subqueries words backreferences matching printing numeric amounts in working days, calculating WW (ISO week) indicator