I just found this works, but I'm still wondering why the more sql approach didn't work:
puts ds.where(kind: 'yellow').count > > -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to sequel-talk+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sequel-talk/d415664f-269c-40e4-8a10-9b5be42f50b9%40googlegroups.com.