(SQL Tutorials for Citizen Data Scientist) SQL Functions SQL has many built-in functions that enable you to perform calculations on data. SQL Aggregate Functions SQL aggregate functions perform calculation on a set of values and return a single value. The following table summarizes some useful aggregate functions: Function Description AVG() Returns the average of values SUM() …

(SQL Tutorials for Citizen Data Scientist) SQL Subqueries In this tutorial you will learn how to embed a query within another query in SQL. What Is a Subquery? A subquery, also known as a nested query or subselect, is a SELECT query embedded within the WHERE or HAVING clause of another SQL query. The data returned by the subquery is used by …

(SQL Tutorials for Citizen Data Scientist) SQL Temporary Tables In this tutorial you will learn how to create temporary tables using SQL. Creating Temporary Tables A temporary table is a table that is visible only to the current session, and is dropped automatically when the session in which it was created is closed. Since temporary tables …

(SQL Tutorials for Citizen Data Scientist) SQL Cloning Tables In this tutorial you will learn how to create a duplicate copy of an existing table. Cloning or Copying a Table There may be a situation when you just want to create an exact copy or clone of an existing table to test or perform something without affecting …