add missing subquery alias