"INNER JOIN" with amount of rows in table

Databases
5

Exactly! One more question though. Can I “always” encapsulate queries in () and give it an alias and use it as result (as long as it’s single cell) ?