SQL QUARIES

1. SELECT: The SELECT statement is used to retrieve data from one or more tables. It specifies the columns to be retrieved and can also include filtering and sorting criteria.

2. JOIN: The JOIN statement is used to combine data from two or more tables based on a common column.

3. WHERE: The WHERE statement is used to filter data based on a condition. It specifies the criteria that must be met for a row to be included in the result set.

4. GROUP BY: The GROUP BY statement is used to group data by one or more columns. It is often used with aggregate functions such as SUM, COUNT, and AVG.

5. ORDER BY: The ORDER BY statement is used to sort data by one or more columns. It can sort in ascending or descending order.

6. HAVING: The HAVING statement is used to filter groups based on a condition. It is similar to the WHERE statement but is applied to groups instead of individual rows.

7. UNION: The UNION statement is used to combine the results of two or more SELECT statements into a single result set.

8. DISTINCT: The DISTINCT statement is used to retrieve unique values from a column in a table.

9. COUNT: The COUNT function is used to count the number of rows or non-null values in a column.

10. SUM: The SUM function is used to calculate the sum of values in a column.

11. AVG: The AVG function is used to calculate the average value in a column.

12. MAX: The MAX function is used to retrieve the maximum value in a column.

13. MIN: The MIN function is used to retrieve the minimum value in a column.