Beginner SQL question: arithmetic with multiple COUNT(*) results
Posted
by polygenelubricants
on Stack Overflow
See other posts from Stack Overflow
or by polygenelubricants
Published on 2010-05-29T07:24:50Z
Indexed on
2010/05/29
7:32 UTC
Read the original article
Hit count: 375
Continuing with the spirit of using the Stack Exchange Data Explorer to learn SQL, (see: Can we become our own “Northwind” for teaching SQL / databases?), I've decided to try to write a query to answer a simple question (on meta): What % of stackoverflow users have over 10,000 rep?.
Here's what I've done:
Query#1
SELECT COUNT(*)
FROM Users
WHERE
Users.Reputation >= 10000
Result:
556
Query#2
SELECT COUNT(*)
FROM
USERS
Result:
227691
Now, how do I put them together into one query? What is this query idiom called? What do I need to write so I can get, say, a one-row three-column result like this:
556 227691 0,00244190592
© Stack Overflow or respective owner