Students


SQL Aggregation Public

Easy  

3min


Given the following data definition, write a query that returns the number of students whose first name is John.

TABLE students
   id INTEGER PRIMARY KEY,
   firstName VARCHAR(30) NOT NULL,
   lastName VARCHAR(30) NOT NULL
SQLite 3.19.3
   

  •   No students named John: Wrong answer
  •   Several students named John: Wrong answer
  •   Every student is named John: Wrong answer