I need to advance this query below to group by date (day) using a join of the 'taken_at_timestamp' column from the table media ( the timestamps are stored as varchar so think you need to use UNIX_TIMESTAMP somewhere
count(*) as count FROM mentions
WHERE caption_mentions ='london_dad'
GROUP by caption_mentions
ORDER BY count DESC;
16 freelancers are bidding on average £17 for this job
Interesting Wonderful project! We are good team in many experiences in Web developing. We are masters of math and web design. If you keep in touch with us, you can get satisfy result. Thanks a lot!
Hello How are you? I am expert in website design and development and i can handle this project. Give me one chance to work with you.... Ready to start your project right now. Thanks sumit chawla