troubleshooting Question

help with a mysql query

Avatar of aej1973
aej1973 asked on
MySQL Server
4 Comments1 Solution326 ViewsLast Modified:
Hello, I have a table with the  format attached. I need help with a query that will give me the following output;

account     tot_jan       count_jan    tot_feb         count_feb       tot_march   count_march
1                  10                  1             10                  1                  null                       0
2                   20                  2             null                0                  20                         2
3                   null                 0             10                 1                   null                       0
########## TABLE STRUCTURE ################
date                amount        account
jan                     10           1
jan                     10           2
jan                      10          2
feb                     10            1
feb                     10            3
march                 10              2
march                 10               2
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros