Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT email, COUNT(*) as chartersperemail
- FROM Charters
- WHERE story IN (
- SELECT story
- FROM Charters
- WHERE story LIKE '%Scout%' OR story LIKE '%scout'
- UNION
- SELECT story
- FROM Charters
- WHERE libname LIKE '%Scout%' OR libname LIKE '%scout'
- )
- GROUP BY email
- HAVING COUNT(*) > 1
- ORDER BY chartersperemail DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement