SQL for Data Analysis

  1. Data Aggregation and Grouping
    1. Aggregate Functions
      1. COUNT Function
        1. COUNT with Asterisk
          1. COUNT with Column Names
            1. COUNT DISTINCT
            2. SUM Function
              1. AVG Function
                1. MIN Function
                  1. MAX Function
                    1. Statistical Functions
                      1. STDDEV
                        1. VARIANCE
                        2. String Aggregation Functions
                        3. The GROUP BY Clause
                          1. Grouping Concepts
                            1. Grouping by Single Column
                              1. Grouping by Multiple Columns
                                1. Grouping by Expressions
                                  1. Grouping by Column Position
                                    1. GROUP BY with NULL Values
                                    2. The HAVING Clause
                                      1. Filtering Grouped Results
                                        1. HAVING vs WHERE
                                          1. Using Aggregate Functions in HAVING
                                            1. Complex HAVING Conditions
                                            2. Grouping Sets
                                              1. ROLLUP Operator
                                                1. CUBE Operator
                                                  1. GROUPING SETS Clause
                                                    1. GROUPING Function
                                                    2. Combining Aggregation with Other Clauses
                                                      1. Aggregation with ORDER BY
                                                        1. Aggregation with LIMIT
                                                          1. Nested Aggregation

                                                        Previous

                                                        4. Advanced Filtering and Selection

                                                        Go to top

                                                        Next

                                                        6. Joining Tables