Inspectopedia
 
2024.3

Each derived table should have alias

Warning
New
Last modified: 03 December 2024

Reports derived tables without aliases.

Example (MySQL):

According to Derived Tables at dev.mysql.com, an alias is mandatory. You can add the alias by using the Introduce alias quick-fix.

After the quick-fix is applied: