In Progress

Simple MySQL statement help

Need help crafting a correct MySQL statement. See below

Sample Data for a table called "viewlog"

LogID User Date

1 UserA 7-25-2011 11:30am

2 UserB 7-25-2011 11:32am

3 UserC 7-25-2011 1:22pm

4 UserA 7-25-2011 11:20pm

5 UserB 7-26-2011 6:22am

6 UserB 7-26-2011 7:12pm

7 UserC 7-27-2011 5:20am

8 UserA 7-27-2011 9:20pm

Desired output (notice the null or 0 value for dates where there are no entres)

User Date NumberOfEntries

UserA 7-25 2

UserA 7-26 0 (or Null)

UserA 7-27 1

UserB 7-25 1

UserB 7-26 2

UserB 7-27 0 (or Null)

UserC 7-25 1

UserC 7-26 0 (or Null)

UserC 7-27 1

I'm just looking for a MySQL expert to craft for me the correct SQL statement for my desired output. No need to set it up in mySQL on my server.

Skills: MySQL

See more: need sql help, crafting, sql statement help, mysql help table, mysql output table, help mysql, mysql statement, mysql output, sql expert need, need mysql expert, output data mysql, simple sql, mysql help, sql server mysql, need null, simple table mysql, mysql date, table simple, mysql date table, mysql sample, insert select statement mysql, online help system mysql php, select insert statement mysql, select statement insert statement mysql, set mysql

About the Employer:
( 18 reviews ) Madison Heights, United States

Project ID: #1150695

Awarded to:

ashwanii

Hi, Please check your PMB. Regards.

$30 USD in 1 day
(4 Reviews)
4.3

10 freelancers are bidding on average $30 for this job

mickeylee112

I can help you, sir! I'm ready!

$30 USD in 0 days
(36 Reviews)
5.4
ruimaxwell

Thank you.

$30 USD in 1 day
(17 Reviews)
5.1
SRajpurohit

let me help u

$30 USD in 1 day
(12 Reviews)
4.7
allroundexperts

Lets start sir !!!

$30 USD in 1 day
(29 Reviews)
4.5
retroshell

Hi, I'm interested to take this project.

$30 USD in 1 day
(10 Reviews)
4.0
kommandant

expert !! check your pm

$30 USD in 0 days
(8 Reviews)
3.8
sanjuintelligo

ready to start now

$30 USD in 0 days
(5 Reviews)
3.2
malagasy

Hi! Allow me to help you. I'm ready to start now. Thanks.

$30 USD in 0 days
(1 Review)
2.7
sprj2011

#################Sir Please check PMB######################

$30 USD in 0 days
(0 Reviews)
0.0