kenjipm/students.sql

Last active April 17, 2022 10:36

Star (2) You must be signed in to star a gist
Fork (1) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/kenjipm/553ab8733d7cb75453f53463e3da9e01.js"></script>
Save kenjipm/553ab8733d7cb75453f53463e3da9e01 to your computer and use it in GitHub Desktop.

Download ZIP

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

Raw

students.sql

SELECT COUNT(*) FROM students WHERE firstName = "John";

alimoghanni commented Apr 17, 2022

SELECT COUNT(*) FROM students WHERE firstName = 'John';

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment