Would this use of a subquery result in an error? Substitute week_ 2 out for week_ 6 if you're trying to replicate. No, you're allowed to plug in a subquery in place of a table Yes, a query cannot use a subquery as a table when using "SELECT *" Yes, the subquery needs to be aliased