Advertisement
Guest User

Untitled

a guest
Oct 20th, 2019
151
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. SELECT email, COUNT(*) as chartersperemail
  2. FROM Charters
  3. WHERE story IN (
  4. SELECT story
  5. FROM Charters
  6. WHERE story LIKE '%Scout%' OR story LIKE '%scout'
  7. UNION
  8. SELECT story
  9. FROM Charters
  10. WHERE libname LIKE '%Scout%' OR libname LIKE '%scout'
  11. )
  12. GROUP BY email
  13. HAVING COUNT(*) > 1
  14. ORDER BY chartersperemail DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement