first you tell me what output you want from these queries.

if you want your query return number of rows then use (b) otherwise use (e)