Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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(*) FROM students WHERE firstName = 'John';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement