remove "al" prefix from subquery since we are only querying one table and do not need to use a prefix.
remove "al" prefix from subquery since we are only querying one table and do not need to use a prefix.