SQL Aggregation is possible by extended relational algebra operators?

SQL grouping is possible in relational algebra.

Relational algebra is equivalent to safe relational calculus expressions, then grouping and aggregation possible in tuple relational calculus and domain relational calculus? What about ordering? Please explain how will we consider these questions from GATE point of view.

In Relational Algebra, Extended Operators are those operators that are derived from the basic operators. We already have discussed Basic Operators . Now let us discuss the Extended Operators and how they are beneficial in Relational Algebra.

There are mainly three types of Extended Operators, namely:

1.Divide

2. Join

3. Intersection

many of the prectical language like SQL...etc have more power compare to relational algebra because grouping ,ordering .......etc

are not supported by Relational algebra but many of practical language are support.