SELECT name ,  LOCATION ,  district FROM shop ORDER BY number_products DESC
Sort all the shops by number products in descending order, and return the name, location and district of each shop.
SELECT name , LOCATION , district FROM shop ORDER BY number_products DESC
select name , location , district from shop order by number_products desc
Sort all the shops by number products in descending order , and return the name , location and district of each shop .