Help with query construction

Question

Need some help with query construction.

database has the following table

table name events

columns: location type int, edate type date, user type varchar, visits type small int.

example records look like

1 2024-01-01 'Bob' 3

1 2024-01-01 'Mary' 13

2 2024-06-01 'Joe' 2

2 2024-06-07 'Joe' 8

I need to sum the visits for a specific location,edate. so the query should return

2024-01-01 16

2024-06-01 2

2024-06-07 8

I tried Select location,edate,sum(visits) from events group by location,edate,visits

but I don't think that's correct.

thanks for any guidance.

Answer 1

Hi @Darryl Hoar

I need to sum the visits for a specific location,edate.

Then you just need to Group By these two specificlocation and edate. As answered above, just remove the visits from the Group By clause.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

I tried Select location,edate,sum(visits) from events group by location,edate,visits

Remove visits from GROUP BY.