Advertisement
Guest User

Untitled

a guest
Jan 21st, 2017
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. SELECT status, count(*) as total_
  2. FROM companydata
  3. WHERE status = 'Not Emailed' or status = 'Not Emailed' or status = 'Email Sent' or status = 'Response Received' or status = 'Interested' or status =
  4. 'Not Interested'
  5. GROUP BY status
  6.  
  7. status total_
  8. -|--------------------|--------------------------
  9. Not Emailed 9562
  10. | Interested | 2
  11. Response Received 45
  12. | Email Sent | 3000
  13.  
  14. Not Emailed Interested Response Received Email Sent
  15.  
  16. 9562 2 45 3000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement