SELECT
    Date,
    RangeFam,
    Country
FROM (
            SELECT  Q_QTM       as Qty,
                    Q_OFDFIN    as Date,
                    Q_PAYS      as Country,
                    CASE Q_DTRI05 
                        WHEN 'eBALTIC - EBB'        THEN 'EBAB'
                        WHEN 'Baltic -'             THEN 'BALT'
                        WHEN 'eBALTIC - EBF'        THEN 'EBAF'
                        WHEN 'Roof-tops - ENERGY'   THEN 'ENER'
                        WHEN 'Roof-tops - FLEXAIR'  THEN 'FLER'
                    END         as RangeFam
            FROM [sales].[dbo].[CARNET2_D]
            WHERE   Q_OFET='D' 
                    and Q_TYPE='M'
    UNION ALL
            SELECT  Qty, 
                    Range_Code as RangeFam,
                    ShippingDate as Date,
                    CASE Country collate DATABASE_DEFAULT
                        WHEN 'France'       THEN 'FRANCE'
                        WHEN 'Netherlands'  THEN 'PAYS BAS'
                        WHEN 'Belgium'      THEN 'BELGIQUE'
                        WHEN 'Portugal'     THEN 'PORTUGAL'
                        WHEN 'Spain'        THEN 'ESPAGNE'
                    END AS Country
            FROM [crmv2].[dbo].[View_Forecastdata_Extended]
            WHERE   BaseUnit='1' 
                    and (Project_status='Detection / Faisability' or  Project_status='Execution' or Project_status='Quotation' or Project_status='Specification stage')
                    and [Report_S3A/B_group]='Rooftop' 
                    and Sop='1' 
                    and SopValid='1'
                    and (Sourcing='L&B' or Sourcing='LON' or Sourcing='BUR')
        ) as T1
ORDER BY Date

SELECT
    Date,
    --RangeFam,
    Country
FROM (
            SELECT  Q_QTM       as Qty,
                    Q_OFDFIN    as Date,
                    Q_PAYS      as Country
                    --CASE Q_DTRI05 
                    --  WHEN 'eBALTIC - EBB'        THEN 'EBAB'
                    --  WHEN 'Baltic -'             THEN 'BALT'
                    --  WHEN 'eBALTIC - EBF'        THEN 'EBAF'
                    --  WHEN 'Roof-tops - ENERGY'   THEN 'ENER'
                    --  WHEN 'Roof-tops - FLEXAIR'  THEN 'FLER'
                    --END           as RangeFam
            FROM [sales].[dbo].[CARNET2_D]
            WHERE   Q_OFET='D' 
                    and Q_TYPE='M'
    UNION ALL
            SELECT  Qty, 
                    --Range_Code as RangeFam,
                    ShippingDate as Date,
                    CASE Country collate DATABASE_DEFAULT
                        WHEN 'France'       THEN 'FRANCE'
                        WHEN 'Netherlands'  THEN 'PAYS BAS'
                        WHEN 'Belgium'      THEN 'BELGIQUE'
                        WHEN 'Portugal'     THEN 'PORTUGAL'
                        WHEN 'Spain'        THEN 'ESPAGNE'
                    END AS Country
            FROM [crmv2].[dbo].[View_Forecastdata_Extended]
            WHERE   BaseUnit='1' 
                    and (Project_status='Detection / Faisability' or  Project_status='Execution' or Project_status='Quotation' or Project_status='Specification stage')
                    and [Report_S3A/B_group]='Rooftop' 
                    and Sop='1' 
                    and SopValid='1'
                    and (Sourcing='L&B' or Sourcing='LON' or Sourcing='BUR')
        ) as T1
ORDER BY Date