Aggregate Query in SQL Developer
Assume you have the following table TAB(name,value)

name value
a        2
a        3
a        2
b        4
b        5
b        5
c        6
c        6
c        6


what are the result sets of the following queries

query 1:

select name, sum(value)
from TAB
group by name
order by name


query 2:

select name, sum(distinct value)
from TAB
group by name
order by name


query 3:

select name, value
from TAB
group by name
order by name