Using COUNT in SQLite3

Question

I am trying to access the details from two joined tables in SQL of 5 categories, for one of which I need to run the COUNT function. I am able to access the details, until I run the count function, after which I am limited to a single result. I have also tried using COUNT(*) as... - but this hasn't worked. The code is as follows:

SELECT name, location, grade_1996, COUNT(voter_id)
FROM votes
JOIN congress_members
ON congress_members.id=politician_id
WHERE grade_current < 9;

Please help, thank you.

Edit your question and provide sample data and desired reult. — Gordon Linoff
– Gordon Linoff, Commented Feb 26, 2017 at 4:22

Gordon Linoff · Accepted Answer · 2017-02-26 04:23:02Z

1

You need a group by. Perhaps this is what you intend:

SELECT name, location, grade_1996, COUNT(voter_id)
FROM votes JOIN
     congress_members
     ON congress_members.id=politician_id
WHERE grade_current < 9
GROUP BY name, location, grade_1996;

answered Feb 26, 2017 at 4:23

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gurwinder Singh · Accepted Answer · 2017-02-26 04:22:55Z

0

You are missing the GROUP BY clause:

select name,
    location,
    grade_1996,
    COUNT(voter_id)
from votes
join congress_members on congress_members.id = politician_id
where grade_current < 9
group by name,
    location,
    grade_1996;

answered Feb 26, 2017 at 4:22

Gurwinder Singh

39.7k6 gold badges62 silver badges87 bronze badges

Collectives™ on Stack Overflow

Using COUNT in SQLite3

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related