[DRG]

There would not be an SQL that sorts by designer/author as there is no SQL entry for designer/author name.

The only way to find all the scenarios by one person assuming they signed their name would be in the search tab of scenhack and enter the designer's name and that will search the txt file that describes the scenario. If you use

Camo Workshop

for example, you will see a number of them from early on.