SELECT u."userId", u."firstName", u."lastName", u."username", COUNT(e."entryId") as "entryCount" FROM "NULLID"."User" as u LEFT JOIN "NULLID"."Entry" as e ON u."userId" = e."postedByUserId" GROUP BY u."userId", u."firstName", u."lastName", u."username" ORDER BY u."firstName", u."lastName" SELECT "userId" FROM "NULLID"."User" WHERE "userId" != AND "username" =