Hey all :) I am currently working on a database and stuck on a question regarding SQL. I know the basics of SQL although this question has me stumped
A list is required of dogs that have career winnings better than that of the average dog. List the dog_id, dog name and the career winnings. A career winning is the sum of all money won by a dog. The solution must include dogs that have not won any prizes when calculating average winnings.
PRIZE
Event_id Place Money
101 1 120
101 2 60
101 3 30
102 1 10
102 2 5
102 3 2
103 1 100
103 2 60
103 3 40
401 1 1000
ENTRY
event_id dog_id place
101 101 1
101 102 2
101 201 3
101 301 4
102 201 2
103 201 3
201 101 1
301 301 2
401 102 7
DOG
Dog Name
101 James
102 Sarah
201 Phillip
301 Jasmine
401 Steven
501 Emma
502 Michael
I am not sure if this is too much to ask but would anyone be able to show me what i am meant to do? I am working on a html project and was suddenly smacked with a SQL question and i need to work this out before i can continue :P
I have always wanted to learn but this html assignment is hard enough without a SQL requirement i have NO idea about lol
Thanks for at least reading this far haha :)