Join

Full Join

full join

Inner Join

inner join

Left Join

left join

left join 2

Right Join

right join

Aggregation Function

  • COUNT().
  • MAX().
  • MIN().
  • SUM().
  • AVG().

The GROUP BY statement groups rows that have the same values into summary rows, like ‘find the number of customers in each country’. The GROUP BY statement is often used with above aggregation functions to group the result-set by one or more columns.