mirzalazuardi · January 18, 2019 04:06
diff --git a/num_of_student.sql b/num_of_student.sql
 -- Students
 -- 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
 SELECT COUNT(*) AS numOfStudent
 FROM students
 WHERE firstName = 'John'
	-- Students
	-- 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
	SELECT COUNT(*) AS numOfStudent
	FROM students
	WHERE firstName = 'John'