I have a table that has following columns:
coin_id, data_item_id, rating, created_at
For each coin_id there's multiple rows from different data sources (marked with data_item_id), and rating from that data source.. but there are dozens of them. What I need is find the latest row for each data source (data_item_id) and get that row's rating. The output for example coin_id 32 should be:
69 is a SUM of ALL ratings from all "latest (determined by created_at column)" data sources.
If you undestand what I'm trying to say, or you have a concrete question ... bid and contact me, otherwise ..don't bother.
I won't hire somebody that thinks he can solve it (and if you know how it's not difficult) .. but rather somebody that really knows how.
16 freelancers are bidding on average $25 for this job
Hi, I would like to write the query to get sum of ratings across coin_id and data_item_id from different sources. Available to start now. Get in touch to discuss more. Regards, Manish
Since I am an Oracle Certified Professional DBA, I have great SQL skills which can get your job done as soon as possible. So I am an ideal person for the job.
Hello How are you I read your job description carefully I have many good experience in Mysql Query I can finish your job quickly and quickly If you hire me, I will do my best and make you satisfied Thanks!