SQL distinc issues : Hi everyone I have a sql table in this format


    Screenname|realname|followers|tweet
    bob       |jim     |5        |hi
    bob       |jim     |20       |hello
    tom       |joe     |15       |JOETHECAT
    tim       |joe     |16       |TEST

I need to write a query that displays each uniques screenname along with there realname and totalnumber of followers.

Screename realname followers
bob       jim      25
tom       joe      15
tim       joe 16





