+ 1

# how can i calculate the number of students with age > x in sql?

4 Answers

+ 3

SELECT COUNT(*) FROM students WHERE age > x

+ 9

Try:
SELECT COUNT(*) FROM STUDENTS WHERE AGE > x

+ 2

you can use alias as well for the count(*):
SELECT COUNT(*) AS 'Total Students' FROM students WHERE age > x

+ 1

SELECT COUNT(*) [TotalStudents] FROM students WHERE age > x