Join: A join is established a connection and creating a relation. Command: sel…
Count: We use count command to compute number of t…
Sum: we use sum command to show the sum of numbers or value…
Average: We use average command to show average…
Min: we use min command to find minimum value from attribu…
Max: we use max command to find maximum value from attribute.…