One such GUI is MySQL Workbench. This particular tool is one of the finest locally installed MySQL client tools you’ll find. It’s cross-platform, open source, and incredibly easy to use.

Provide a schema name Click apply to create the MySQL scheme The MySQL workbench executes the required SQL statement under the covers, and the schema is listed in the tool. With the schema created, ...

An alternative - again, if supported - would be to create a view that works the same as the derived table, and use this in your query instead.