How many times will the inner query SELECT MAX(LastUpdatedOn) FROM DigitalAsset
run? Only once or once per row for the outer query?
SELECT FirstName
FROM Actors
INNER JOIN DigitalAssets
ON ActorId = Id
WHERE LastUpdatedOn = (SELECT MAX(LastUpdatedOn)
FROM DigitalAssets);