Good afternoon. I need to make a query that outputs the authors of books sorted by the number of books in decreasing order. You only need to output authors whose number of books is greater than the average number of books by authors. A sample of my table, in which I managed to get only the average value, is here:
3xz42mecq - MySQL - OneCompiler
onecompiler.com