Thank you for the response

but no.

Im looking for a new query that produces exactly the same results as the example I give.

The only problem with my code, that is:

(SELECT SUM(SALES)...