A simple search query between location and visit tables. Location has a name. Visit has a start date, end date, and a location id. A location can have many visits. So location id is shared between visit and location - its the key in the visit table. The query needs to output json data. I send in a start date and end date. Based on that I should get the total number of visits per start_date per location.
17 freelancers are bidding on average $62 for this job
Hello, I am graduated software engineer and professional Rails developer for more than 3 years. If you want consistent & robust system, please consider me. You can check my profile reviews to see happy clients. Thanks!