I have a broadsheets table with student_id 5 and 6 but when I run the query in the image I get just one row but if I remove the group by I get all 6 rows in the broadsheets table. Please I need assistance

Why not just screenshot your laptop?

Karleb:
Why not just screenshot your laptop?

Will do that

This is the code I have written

goldmines214:
This is the code I have written

Group by is used in conjunction with an aggregation function but with you query I don’t see how group by is helpful.

stanliwise:

Group by is used in conjunction with an aggregation function but with you query I don’t see how group by is helpful.

I know that but I also want to select from the students and subjects tables but if I use aggregate functions let's say max(students.fname) then it means that I will be looking for the maximum of students first name instead of all the students names.
Please How do I arrange the above query so the group by can be helpful?

goldmines214:


I know that but I also want to select from the students and subjects tables but if I use aggregate functions let's say max(students.fname) then it means that I will be looking for the maximum of students first name instead of all the students names.
Please How do I arrange the above query so the group by can be helpful?

For group by to work, all column you select must have exactly same content except the aggregator column.

Meanwhile in your sql statement you made no use of aggregator so why do want to use group by

To put things straight you are not aggregating anything and so you don’t need a groupBy it is as simple as that.

stanliwise:

For group by to work, all column you select must have exactly same content except the aggregator column.

Meanwhile in your sql statement you made no use of aggregator so why do want to use group by

To put things straight you are not aggregating anything and so you don’t need a groupBy it is as simple as that.

What I am trying to achieve is that I have different students offering different subjects with the subjects scores so I was thinking I can group by the student_id and so that I can add all the subjects scores offered by a particular student

goldmines214:


What I am trying to achieve is that I have different students offering different subjects with the subjects scores so I was thinking I can group by the student_id and so that I can add all the subjects scores offered by a particular student

Then simply do something like

select student_id, SUM(subject_score) ...... group by student_id

It would be of the above nature, you can add the rest join but don’t add extra column that could make the return two appear different

stanliwise:

Then simply do something like

select student_id, SUM(subject_score) ...... group by student_id

It would be of the above nature, you can add the rest join but don’t add extra column that could make the return two appear different

I like this idea but how do I select the other columns like name from students table and subject_name from subjects table then join it to this your query.
Please help

goldmines214:



I like this idea but how do I select the other columns like name from students table and subject_name from subjects table then join it to this your query.
Please help

If you’re trying to get the sum then it has to be separate query.
Selecting student. Meta data has to also be a separate query.

Meanwhile if you want to add all query in same query forget using grouped by.

Now something is even confusing about your query, if you need details about just a student then what do you need groupBy for ?

stanliwise:

If you’re trying to get the sum then it has to be separate query.
Selecting student. Meta data has to also be a separate query.

Meanwhile if you want to add all query in same query forget using grouped by.

Now something is even confusing about your query, if you need details about just a student then what do you need groupBy for ?

The query is not just for a single student. It's for all students in a class. It's a school broadsheet

This is a simple query I wrote and it's still showing me one record instead of two. I have two student_id 5 and 6 in my broadsheets table.
What must be wrong?