The least amount of code possible for this MySQL query?

Posted by ddan on Stack Overflow See other posts from Stack Overflow or by ddan
Published on 2012-03-24T03:06:13Z Indexed on 2012/03/24 5:29 UTC
Read the original article Hit count: 143

Filed under:
|
|
|
|

I have a MySQL query that:

  • gets data from three tables linked by unique id's.
  • counts the number of games played in each category, from each user
  • and counts the number of games each user has played that fall under the "fps" category

It seems to me that this code could be a lot smaller. How would I go about making this query smaller. http://sqlfiddle.com/#!2/6d211/1

Any help is appreciated even if you just give me links to check out.

© Stack Overflow or respective owner

Related posts about mysql

Related posts about select