How can I make my query more efficient and order result

Hello (:

I would like to know how I can order my queries because I cannot use "ORDER BY" and instead the "GROUP BY" fulfills its function but without order.

also

When of the 3 queries it is greater than 2000 rows, it takes a long time to do the "FULL JOIN" with respect to whether table1.time = table2.time.

ALTER PROCEDURE [dbo].[Datos_1] @linea int, @d1 varchar(30), @d2 varchar(30)
AS
WITH 

s as (
  select Datepart(HOUR, created_at) as hora,  
  CAST (isnull(avg(entrada_1),0)AS DECIMAL(10,2)) as 'entrada' 
  from entrada_temp where created_at between @d1 and @d2 and id_linea = @linea 
  group by ROLLUP(  datepart(HOUR, created_at))
),      
e as (
  select Datepart(HOUR, created_at) as hora, 
  CAST(isnull(avg(esmalte_1),0) AS DECIMAL(10,2))as 'esmalte' 
  from esmalte_temp where created_at between @d1 and @d2 and id_linea = @linea 
  group by ROLLUP ( datepart(HOUR, created_at))
),      
f as (
  select Datepart(HOUR, created_at) as hora, 
  CAST(isnull(avg(salida_1),0) AS DECIMAL(10,2)) as 'salida' 
  from salida_temp where created_at between @d1 and @d2 and id_linea = @linea 
  group by ROLLUP ( datepart(hour, created_at))
)

SELECT top 9
  COALESCE(s.hora,e.hora, f.hora) as hora,
 isnull(s.entrada,0) as 'entrada', 
isnull(e.esmalte,0) as 'esmalte',
isnull(f.salida,0) as 'salida'
FROM
  s
FULL JOIN e ON (e.hora = s.hora)
FULL JOIN f ON (f.hora = s.hora)