Write an SQL query

I have created a database which contains large amounts of horse racing data. I now want to query this database in order to retrieve various statistics.

I have attached the structure of my database but the data is not included (you’ll no doubt be able to enter your own test data).

I need somebody to help me write an SQL query (if we need to add some PHP to help that’s fine) which selects 100 winning horses, classed as “today” (there will be extra filters but these can be added at a later date).

Once those horses have been selected I have attached a table showing what output is required.

I welcome your thoughts, questions and quotes.

Regards, Chris