Multi-Level Query

I have following situation on an Access Database.

ADA# NAME SPONSOR's ADA#
123 JOHN 111
124 MIRA 111
125 SAM 124
126 RAM 125
127 MERRY 124
128 JOHNY 124
129 BUCH 111
111 MAJOR 110
112 SURAJ 110

Now I want to write a query which will give me listing sponsor wise e.g.:
ADA # Level Name SPONSOR's ADA#
111 1 MAJOR 110
123 2 JOHN 111
124 2 MIRA 111
125 3 SAM 124
126 4 RAM 125
127 3 MERRY 124
128 3 JOHNY 124
129 2 BUCH 111

This has to be nested query but I am not sure go to go ahead...

Is anybody outthere to guide me

Thanks