Qry = Clomosy.DBSQLiteQueryWith(

      'SELECT City AS city, sales, ' +

      '  CASE RowNum ' +

      '    WHEN 1 THEN "clTomato" ' +

      '    WHEN 2 THEN "clGold" ' +

      '    WHEN 3 THEN "clPeru" ' +

      '    WHEN 4 THEN "clYellow" ' +

      '    WHEN 5 THEN "clPink" ' +

      '  END AS color ' +

      'FROM ( ' +

      '  SELECT City, COUNT(*) AS sales, ' +

      '         ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC) AS RowNum ' +

      '  FROM Orders ' +

      '  JOIN Customers ON Customers.CustomerId = Orders.CustomerId ' +

      '  WHERE strftime("%Y", Orders.OrderDate) = "' + secilenYil + '" ' +

      '  GROUP BY City ' +

      ') ' +

      'WHERE RowNum <= 5 ' +

      'UNION ALL ' +

      'SELECT "Diğer" AS city, COUNT(*) AS sales, "clwhite" AS color ' +

      'FROM ( ' +

      '  SELECT City, COUNT(*) AS sales, ' +

      '         ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC) AS RowNum ' +

      '  FROM Orders ' +

      '  JOIN Customers ON Customers.CustomerId = Orders.CustomerId ' +

      '  WHERE strftime("%Y", Orders.OrderDate) = "' + secilenYil + '" ' +

      '  GROUP BY City ' +

      ') ' +

      'WHERE RowNum > 5'

    );