How to create the table for these expecting output?

Question

Hi Friends,


i ve the table structure like


create table geoloc
(
pincode int primary key,
latitude float,
longitude float
)


insert into geoloc values('600004','13.0656','80.2672')

insert into geoloc values('600028','13.0206','80.2417')


create table cust_det
(
cust_id int,
pincode int foreign key references geoloc(pincode),
sales int
)


insert into cust_det values('101','600004','100')
insert into cust_det values('102','600004','150')
insert into cust_det values('103','600004','200')
insert into cust_det values('104','600028','300')
insert into cust_det values('105','600028','450')

in my application i m display the marker from database when i click the marker for particular marker now opens the info window in that i wanna show particular area sales


ex:

in 600004 marker i m choosen means the window ll show


cust sales

101 100
102 150
103 200

total 450


how to make code?