Advertisement
Guest User

Untitled

a guest
May 22nd, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. Given the following data definition, write a query that returns the number of students whose first name is John.
  2.  
  3. TABLE students
  4. id INTEGER PRIMARY KEY,
  5. firstName VARCHAR(30) NOT NULL,
  6. lastName VARCHAR(30) NOT NULL
  7.  
  8.  
  9. SELECT COUNT(*) FROM students WHERE firstName = 'John';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement