text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  CREATE TABLE shop (name VARCHAR, LOCATION VARCHAR, district VARCHAR, number_products VARCHAR)
  ### Question:
  Return the name, location and district of all shops in descending order of number of products.
  ### Answer:
  SELECT name, LOCATION, district FROM shop ORDER BY number_products DESC