Loading collection data...
Collections are a way for you to organize kata so that you can create your own training routines. Every collection you create is public and automatically sharable with other warriors. After you have added a few kata to a collection you and others can train on the kata contained within the collection.
Get started now by creating a new collection.
Fair point, though Alexander's comment about the query optimizer is worth considering as well.
The reason I wrote a query like this as well is that if you want to change the filter from
> 50
to> 10
, you only need to change the number in one place here.Exactly my thoughts...
Ohhh, things are not so simple. Firstly when you search data by the condition of the range you almost always get full table scan, the second important factor is the availability of a index by the field, order of the fields in the index, type and parameters of index, the third is the implementation of a query optimizer in a concrete database.
Slight improvement would be to add additional criteria on each join, to restrict the rows during the join
The subquery here is poor practice. Suprising this is getting best practice votes. The query forces creation of a full set of data which is then filtered on the 'outer' where. Consider these can be moved in to each query from ussales and eusales.
It certainly is