I have a really slow SQL statement which I believe I can optimise using conditional count() statements but I can't work out how to do this.

```
SELECT TOP 10 U.UserID,
                U.Fullname,
                U.URL,
                U.Fname,
                U.ProfilePic,

  (SELECT Count(ResourceID)
   FROM resources R
   WHERE R.UserID = U.UserID) AS ResourcesPosted,

  (SELECT Count(JobID)
   FROM Jobs J
   WHERE J.UserID = U.UserID) AS JobsPosted,

  (SELECT Count(AuditID)
   FROM Audit_Trail AT
   WHERE AT.UserID = U.UserID
     AND TYPE = 1
     AND Entry LIKE '%logged in%') AS TotalLogins,

  (SELECT Count(EventID)
   FROM Future_Events_Listing E
   WHERE E.UserID = U.UserID) AS EventsPosted
FROM User_basics U
LEFT JOIN Pod_Membership PM ON PM.userID = U.UserID
WHERE PodID = 268

```

Could I do some sort of inner join and then conditionally count the items?