SET NOCOUNT ON;
USE tempdb;
GO
CREATE TABLE dbo.t1 (
  Id int,
  Azienda varchar(10),
  Garage varchar(10),
  [Auto] int,
  Moto int
  );
INSERT INTO dbo.t1
  VALUES (1, 'FIAT', 'garage1', 2, 3), (2, 'FIAT', 'garage1', 2, 3);
INSERT INTO dbo.t1
  VALUES (3, 'ALFA', 'garage1', 2, 3), (3, 'ALFA', 'garage2', 2, 3);
GO
SELECT t1.Azienda
  , SUM(CASE WHEN t1.Garage = 'garage1' THEN t1.[Auto] ELSE 0 END) AS [garage1-auto]
  , SUM(CASE WHEN t1.Garage = 'garage1' THEN t1.[Moto] ELSE 0 END) AS [garage1-moto]

  , SUM(CASE WHEN t1.Garage = 'garage2' THEN t1.[Auto] ELSE 0 END) AS [garage2-auto]
  , SUM(CASE WHEN t1.Garage = 'garage2' THEN t1.[Moto] ELSE 0 END) AS [garage2-moto]

  FROM dbo.t1 t1
  GROUP BY t1.Azienda
GO
DROP TABLE dbo.t1;
--<-------
Azienda    garage1-auto garage1-moto garage2-auto garage2-moto
---------- ------------ ------------ ------------ ------------
ALFA       2            3            2            3
FIAT       4            6            0            0