Sql query ..help plz urgent

Hi i need some help very urgently

i have three tables in a database

and i need to get a report that shows for each scalper, which concert gives him the best return per ticket price (price he paid from the ticket office / cost he charges when selling it) It should return me the scalper name, concert Date and best return

Can u please help..


Scalpers

primary key is scalper and concert
Scalper Concert Cost Number
yea 12/01/2003 $99.00 20
Tony 12/01/2003 $101.00 50
Tony 2/02/2003 $40.00 40
Johnnie 2/02/2003 $39.00 15
Georgie 2/02/2003 $55.00 99
Georgie 7/02/2003 $130.00 99
Johnnie 7/02/2003 $92.00 8
Johnnie 3/03/2003 $40.00 12
Tony 3/03/2003 $42.00 20
Georgie 3/03/2003 $60.00 60
Johnnie 4/03/2003 $150.00 22
Georgie 4/03/2003 $140.00 44
Johnnie 11/03/2003 $150.00 22
Tony 11/03/2003 $100.00 88
Tony 17/03/2003 $50.00 33
Georgie 17/03/2003 $5.00 55
Johnnie 17/03/2003 $55.00 27
Tony 31/03/2003 $55.00 23
Georgie 31/03/2003 $60.00 32
Georgie 4/04/2003 $68.00 22
Tony 4/04/2003 $67.00 21
Georgie 6/05/2003 $60.00 44
Tony 6/05/2003 $60.00 44
Tony 22/05/2003 $30.00 30
Georgie 22/05/2003 $31.00 31
Johnnie 22/05/2003 $32.00 32




Performers Primary key is Performer Performer Music
Tripod Comedy
Tool Hard Rock
Cradle of Filth Metal
The Beatles Pop
Avril Lavigne Pop
Pennywise Punk
Ja Rule Rap
Bob Marley Reggae
B2k RnB
P Diddy RnB
Usher RnB
Incubus Rock
Grinspoon Rock
Justin Timberlake Urban


Concerts Primary key is Date Performer Date Price
Avril Lavigne 12/01/2003 $80.00
The Beatles 25/01/2003 $64.00
Pennywise 30/01/2003 $66.00
Usher 2/02/2003 $30.00
The Beatles 4/02/2003 $16.00
Avril Lavigne 7/02/2003 $79.00
Pennywise 28/02/2003 $66.00
Usher 3/03/2003 $35.00
Avril Lavigne 4/03/2003 $78.00
Avril Lavigne 11/03/2003 $78.00
Incubus 17/03/2003 $48.00
The Beatles 22/03/2003 $8.00
Grinspoon 26/03/2003 $35.00
Incubus 31/03/2003 $49.00
The Beatles 1/04/2003 $32.00
Incubus 4/04/2003 $50.00
Grinspoon 11/04/2003 $35.00
The Beatles 15/04/2003 $4.00
Pennywise 22/04/2003 $66.00
Pennywise 29/04/2003 $66.00
The Beatles 5/05/2003 $2.00
Incubus 6/05/2003 $50.00
Pennywise 11/05/2003 $66.00
Usher 22/05/2003 $25.00
Pennywise 23/05/2003 $66.00



thanks

kushal