Completed

assistance with mysql query

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

SELECT caption_mentions,

count(*) as count FROM mentions

WHERE caption_mentions ='london_dad'

GROUP by caption_mentions

ORDER BY count DESC;

Skills: Database Administration, Database Programming, MySQL

See more: help with sql server, mysql tutorial, mysql help online, mysql help forum, sql live help, mysql help command line, coding help, developers help, edit csv mysql query, asp mysql query, 2013 lost connection mysql query, mysql query report, php mysql query table, mysql query record bash, mysql query csv file, write mysql query, optimize mysql query software, mysql query php table css, php mysql query format table, mysql query search

About the Employer:
( 4 reviews ) croydon, United Kingdom

Project ID: #19794429

Awarded to:

sergeyprince

Hello. I looked carefully at your posts. mysql database manage & programming is my best work. also i have a enough history in this part. If you have the opportunity to talk to me, I think I can create a less cost e More

£20 GBP in 0 days
(8 Reviews)
2.6

16 freelancers are bidding on average £17 for this job

shiningdevelopor

Hi . I am very interested in your project. I have 7 years of web development experience such this projects. If you have good idea, I will do make your idea perfectly and at a short time. Hope to discuss more detail. L More

£15 GBP in 7 days
(49 Reviews)
6.2
mak94pk

Hello Sir/Mam, MAKSOF is a team of highly qualified professionals who is dedicated in providing creative solutions and innovative ideas for your business with our skills in technologies and strategies. We have r More

£18 GBP in 1 day
(24 Reviews)
5.1
seefattechnologi

Hello!! I am mysql query Developer having more then 5 years experience in mysql query development. Skills: JavaScript, PHP, WordPress, HTML5/CSS3/Bootstrap3, Jquery, MySql I would like to arrange an interview with y More

£20 GBP in 7 days
(17 Reviews)
4.9
xinglong717

Hi. I've read carefully your job description I'm have a lot of experiences in JAVA, C++, VB, DATABASE ,SQL QUERY, .... And I also have experiences in Excel VBA developing and data mining. If you hire me, then I will More

£15 GBP in 7 days
(30 Reviews)
5.1
jinxing4

Dear Sir. I am interested in your project. I'm senior Laravel, PHP, SQL, Javascript developer. I assure, I will do my best to work with you on your project to present the best possible outcome for you and your custo More

£20 GBP in 1 day
(16 Reviews)
4.2
happyday2008drea

How about it? "SELECT mentions.caption_mentions, count(*) as count FROM mentions Join media [login to view URL] = TIMESTAMP(media.taken_at_timestamp) WHERE caption_mentions ='london_dad' GROUP by mentions.caption_mentio More

£15 GBP in 1 day
(6 Reviews)
4.3
KimHyokJun

Hi, glad to bid on your project. I have read your description. I have skills in db management and programming related to db. I have worked 7+ years in DBMS. I think I am suitable for you to do that quickly and perf More

£30 GBP in 1 day
(7 Reviews)
3.6
manjeet2017

Hello Just to introduce my self ,I have more than 5+ years of experience in design & development. And as a policy we will provide 3 month maintenance "free of cost" for the project done by us. Now coming on this More

£18 GBP in 1 day
(7 Reviews)
3.3
eden134

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!

£30 GBP in 7 days
(1 Review)
2.8
sumitchawla3625

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

£15 GBP in 7 days
(4 Reviews)
2.8
rajan6533

Hi Thanks for the opportunity to place bid on this project. I carefully read the comments and thought about the points to consider in the project. There are many sql database development experiences. I think I can More

£10 GBP in 1 day
(3 Reviews)
2.5
valiksoin

dear. I am Valentin.S in Russia. I am expert in mysql query I can help you as well very fast thank you

£15 GBP in 1 day
(3 Reviews)
2.7
sarvya521

Hi I am experience software engineer. I possess strong knowledge in SQL, PL-SQL with MySQL, SQL Server and Oracle databases. I have delivered projects in time and within budget. I am the best fit for your task. Award m More

£10 GBP in 1 day
(3 Reviews)
2.2
TopDesigner315

Hello.I am a Web developer. I am interesting on your project and I have 6+ yeasr of experience of working MySql I can implement your project with fully and completely. I can help you with my best. Thanks for your p More

£10 GBP in 1 day
(1 Review)
1.3
aap31374

I have more then 15 years of experience in DBMS and immediately available

£18 GBP in 1 day
(0 Reviews)
0.0