How do I use 2 or more different where, sum or group by clauses in same statement

Question

0.00/5 (No votes)

See more:

I am trying to have a table with various output on one row.
Cannot get results on one table row.

An example is like this where I get answer

I am using a pre 2012 version of MySQL for coding

What I have tried:

SELECT `Bowler`,`Date`,`Gm1`
FROM `b_Scores` 
WHERE `Gm1` > 200 and Date = 2016-09-20
group BY Team

SELECT `Bowler`,`Date`,`Gm1`
FROM `b_Scores` 
WHERE `Gm1` > 300 and Date = 2016-10-20
group BY League;

Posted 2-Mar-17 8:57am

Member 12995602

Updated 2-Mar-17 9:09am

Sean Ewington

Add a Solution

Comments

Bryian Tan 2-Mar-17 22:15pm

how the expected result should look like?

CHill60 3-Mar-17 7:24am

You can't have things like Bowler, Date and Gm1 in the select if you are going to group by team. Can you post working queries and your expected results and we can help you get them into a single query

Member 12995602 3-Mar-17 19:05pm

Here is a sample of working code that works separately or on 2 separate rows if a ";" is placed after the 1st code.

SELECT date,bowler,
SUM(Gm1+Gm2+Gm3)
FROM b_Scores
WHERE Week= 20 and TeamNum = 1
GROUP BY Bowler;

SELECT date,team,
SUM(Gm1+Gm2+Gm3)
FROM b_Scores
WHERE Week= 20 and TeamNum = 1
GROUP BY Team

What I need is a table with separate similar data on different rows by date.

Member 12995602 3-Mar-17 19:17pm

for reference i am trying to program various items similar as this page.
https://brechinlanes.ca/wp-content/uploads/2013/06/MMIX_09-19-16.pdf

The results will be automatic rather than uploading a pdf file.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)