41⟩ Explain the difference between union and group?
The difference between union and group is as follows:
take two tables t1 and t2.
in t1 we have columns like a,b,c,d. and t2 has a,d,e,f.
so union means t1 union t2 i.e getting result from both tables i.e a,b,c,d,e.,f
where as group performs on a individual column in a particular table.