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.
15 pekerja bebas membida secara purata $26 untuk pekerjaan ini
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
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!