SELECT u."userId", u."firstName", u."lastName", u."username", COUNT(e."entryId") as entryCount FROM "User" u LEFT JOIN "Entry" 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 "User" WHERE "userId" != AND "username" =