You cannot apply on this project as you are not part of any company. Please add new or join existing company.
Sorry, you cannot apply on this project. But you can apply on many other projects. Find More Projects

Counting in date order with a criteria SQL Closed

I have a horse racing database in SQL. I'm trying to count in ascending order from the horses most recent run to its first start. So it's most recent start will be 1 and if it's had 15 career starts its first start will be 15.

I am not sure where to start in SQL as I'm a newbie with it but I'm working currently with Excel at the moment and the data set is getting too big.

I have a data sample with expected outcome to view if you need it with columns race date, horse name, total runs and then runs from now which is the column I'm trying to create in SQL.

This job was posted from a mobile device, so please pardon any typos or any missing details.

Budget: $20

Posted On: August 13, 2017 23:30 UTC
Category: Web, Mobile & Software Dev > Web Development
Skills: MySQL Administration, MySQL Programming, SQL
Country: Australia
ID103229 TitleCounting in date order with a criteria SQL
TypeHourly Budget$16-$50
Is PrivateNo Created On10 months ago