Added subquery. Please check missing ones.