使用变量使用一个SELECT语句对多个表进行SQL查询

I'm pretty new to SQL, but given the below example is there a way to condense the query? From my understanding SQL does not have arrays, but is it possible to store the tables somehow and do one SELECT statement, as maybe a variable (Select Count(*) From Table_Name) As Table_Name)?I'm pretty new to SQL, but given the below exam