Join with group by

Question

I want to use group by with join on below data:

statistics:

| id | user_id| date|

users:

| id | name | age|

My query which doesn't return table users:

SELECT user_id, sum(time_to_sec(date)/60) as mins 
from `statistics` 
JOIN user ON users.id = statistics.user_id 
WHERE 1 and user_id=8 group BY user_id

Can anyone help?

The `WHERE 1 and...` is not necessary since you have another condition in the where clause. Could instead be `WHERE user_id=8`. — Jens Wegar, Nov 15 '18 at 12:27
Possible duplicate of [SQL JOIN, GROUP BY on three tables to get totals](https://stackoverflow.com/questions/1242121/sql-join-group-by-on-three-tables-to-get-totals) — , Nov 15 '18 at 13:20

score 3 · Answer 1 · answered Nov 15 '18 at 12:21

3

Table name in Join is wrongly mentioned. it should be users not user as per your table definition.

answered Nov 15 '18 at 12:21

Sekar Ramu

343
1
2
11

score 1 · Answer 2 · edited Nov 15 '18 at 12:23

1

Typo mistake I think

JOIN user ON users.id = statistics.user_id

Try this

JOIN users ON users.id = statistics.user_id

edited Nov 15 '18 at 12:23

Lelio Faieta

6,457
7
40
74

answered Nov 15 '18 at 12:22

mukund

29
5

Join with group by

2 Answers2