change query of storages in neighbouring countries - #283

SELECT
    B.cntr_id,
   'NEP 2035' as scn_name,
   row_number() over () + 200000 as storage_id,
   B.bus_id as bus,
   'flexible' AS dispatch,
   'PV' AS control,
   nominal_value[1] AS p_nom,
   FALSE as p_nom_extendable,
   0 as p_nom_min,
   -1 as p_min_pu_fixed,
   1 as p_max_pu_fixed,
   1 as sign,
   11 as source,
   0 as marginal_cost,
   0 as capital_cost,
   1 as efficiency,
   0 as soc_inital,
   true as soc_cyclic,
   6 as max_hours,
   0.88 as efficiency_store, -- efficiency_store according to Acatech2015 
   0.89 as efficiency_dispatch, -- efficiency_dispatch according to Acatech2015 
   0.00052 as standing_loss -- standing_loss according to Acatech2015
 
 		FROM calc_renpass_gis.renpass_gis_storage A join
 		(
 		SELECT
 		*
 		FROM
 			(SELECT *,
 			max(v_nom) over (partition by cntr_id) AS max_v_nom
 			FROM
 			model_draft.ego_grid_hv_electrical_neighbours_bus
 			where central_bus = True
 			) SQ
 		WHERE SQ.v_nom = SQ.max_v_nom
 		) B
 		ON (substring(A.source, 1, 2) = B.cntr_id)
 	WHERE substring(A.source, 1, 2) <> 'DE'
 	AND A.nominal_value IS not NULL
 	AND A.nominal_value[1] > 0.001
 	AND A.source not LIKE '%%powerline%%'
 	AND A.scenario_id = 41
Group by bus, p_nom, B.cntr_id;