Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Original query
- SELECT COUNT(*)FROM players
- WHERE (bats = "L" AND throws = "R") OR (bats = "R" AND throws = "L");
- -- Query that returns a single person more than the original one
- -- Student homework: to explore who that player is and why does it return exactly him
- -- Students have to send the way they used to find the extra player
- SELECT COUNT(*)FROM players
- WHERE bats != throws
- AND bats != "B" AND throws != "B" AND bats IS NOT NULL and throws IS NOT NULL;
Advertisement
Add Comment
Please, Sign In to add comment