Suppose that I have a table called politics and with this folowing fields

delegates: c(20)
City:         c(20)
State:       c(5)

And I want to generate this sort or report. Can it be done with an SQL statement?
(I know how to do it with a do while loop.)

delegate, City
Robert     Phoenix
Smith     Snow Flake
Burns     Snow Flake
etc.
           Az: Delegates: 3

Stevens  San Diego
Jerome   Los Angeles
          Ca:  Delegates 2
etc.
etc.

Thanks
Steve