CODE EXAMPLE FOR SQL

odata expand and $select only column values

Categories?$expand=Products($filter=DiscontinuedDate eq null)
Categories?$expand=Products/$count($search=blue)