Given the relations
Which of the following queries cannot be expressed using the basic relational algebra operations $\left(\sigma, \pi,\times ,\Join, \cup, \cap,-\right)$?
Possible solutions, relational algebra:
(a) Join relation using attribute dpart_no.
(d) Let the given department number be $x$
(c) We cannot generate relational algebra of aggregate functions using basic operations. We need extended operations here.
SQL Query without aggregation but as said by @reena_kandari can't do sum operation!
SELECT DISTINCT x FROM table WHERE x NOT IN (SELECT table1.c FROM table AS t1 JOIN table AS t2 ON t1.c < t2.c)
@ashutoshaay26 what's the output of this query?
Thank you so much Arjun Sir!