...position in a race. So if a racer has results from 10 races, we want to get only the top 3 and we need to SUM the total of their points in order to list the top three racers in a query Have tried with clever things like SELECT driver, SUM(`position`) FROM (SELECT driver, race, season, `position`, IF(@lastDriver=(@lastDriver:=driver), @auto:=@auto+1
...goes up to say 200 the server cannot process the query fast enough and the whole server stops. Old processes are backing up and new ones are coming in faster than old ones can be processed. I had a developer add this functionality and he is no geolocation expert. He added the table and used a basic query. By what I've had a chance to read online this
...select values is this session_id mentioned above. In the view, I only want to show records for the session_id associated with the current date. If I use MAX(session_id) in my query, I will get older session_id if they are the newest. If I don't aggregate this data, I get repeating records. Instead, there should be a single record for each person defined
...somewhere, but either way the final output will be as per the attached image, varied for the 80 different product types. If you don't think you understand this brief, make your query before bidding. Please do not bid just to talk to us. ONLY Bids to do the work will be reviewed. This is a technical job, so I don't need to see portfolios, or a list of what
Local business search for particular area.. Website developer s from Pune please contact me .
I have a product I am designing and need to see if it inflicts with any patents in the USA that are current, and if it would be possible to patent it as well. Will give you more information over messaging, thanks!
Physical Modeling Design & Structured Query Language (SQL)
...(embedding weblink into app) - I have some historic datasets from previous races that I am currently organising and would love the ability to create a mobile app for competitors to search their results, compare them with other riders and perhaps track their progress - I also use a professional timing system that can push current race data to an ftp site. If
An open world survival game where the player has minimal equipment which t...the scene and I require the blocks to be saved connected and for the location of every construction made to be stored. After that has been completed, I require a script or query to be written so other objects like player statistics and inventory to be saved into the database.
I need help with my project, someone who can help me in the following technologies: Docker Docker Compose Node.js Express Graph Query Language and tools Angular 4 Angular Material 2.0-beta.6 - no docs available unstable version Mongodb Serverless Nile Deployment Platform Someone who is available 5-7 am est here - mon to fri
...& readable screens with comments in code, modular design approach, future expansion & addition of modules. 4. View, Print & Export to standard formats of data base tables /query based general requirements. 5. User log and Table backups with automated procedures wherever required. 6. EMAIL provision with SMTP authentication for communicationg between
...will be done in AWS and return a “job status” code or results/total successful API’s, etc. - We want to pass to AWS API a list of all API URL’s and/or path-variables and/or query string parameters. - This batch list of urls that need to be invoked will be sent somehow to AWS, such as in a HTTPWebRequest Body (JSON). - AWS wil have to “loop through”
I’m looking for someone to integrate a lab testing restful API into our existing ReactJS & Redux app. Please see the project scope below: - Query lab locations using the api - Order a test using the api — Using a form, create order through api after accepting valid payment. — Send an email to the customer with the order details. - Retrieve API test
I need someone that is highly reliable, has a good amount of experience on SEO and also has case studies to prove their results. Please only apply if you can do bi-weekly reports on what has been done and take more than 2-3 projects at the same time, thanks! This is a recurring month by month project *
I have a MySQL database that has data where a primary key by postcode. I would like to allow users to search that database (from a front end webpage) by postcode and display for them, the total number of records (just a summary count of the records... do not display the contents of data records (the user will be able to purchase the data records for
Create a professional bright and colorful logo for a search similar to KAYAK
...knowledge about user modeling in dialogue systems required * Imagine a user that needs simple words for an explanation. I want you to create a program (in python) that can query Wordnet and find synonyms for words. There must be a function that given a word, it returns synonyms. def syn(word) will return a list of synonyms. Note: Complete commenting
...numbers of #'s the term would have to have had 4. The user would decide whether to search twitter/instagram or both 5. They could decide if they wanted to look for other extensions than .com (if left blank then it would just search for .com's) Upon then searching the query would pull back a list of the most popular .com's still available with the chosen