SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE [dbo].[Customer](
	[ID_Customer] [int] NOT NULL,
	[Name_Customer] [varchar](70) NULL,
 CONSTRAINT [PK_Customer] PRIMARY KEY CLUSTERED 
(
	[ID_Customer] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[Vehicle](
	[ID_Vehicle] [int] NOT NULL,
	[ID_Customer] [int] NOT NULL,
	[ID_Vehicle_Type] [int] NOT NULL,
	[Sell_Date] [date] NULL,
	[Vehicle_Model] [varchar](70) NULL,
	[Sell_Price] [decimal](12, 2) NULL,
 CONSTRAINT [PK_Vehicle] PRIMARY KEY CLUSTERED 
(
	[ID_Vehicle] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[Vehicle_Type](
	[ID_Vehicle_Type] [int] NOT NULL,
	[Name_Vehicle_Type] [nvarchar](50) NULL,
 CONSTRAINT [PK_Vehicle_Type] PRIMARY KEY CLUSTERED 
(
	[ID_Vehicle_Type] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

ALTER TABLE [dbo].[Vehicle]  WITH CHECK ADD  CONSTRAINT [FK_Vehicle_Customer] FOREIGN KEY([ID_Customer])
REFERENCES [dbo].[Customer] ([ID_Customer])
ALTER TABLE [dbo].[Vehicle] CHECK CONSTRAINT [FK_Vehicle_Customer]
ALTER TABLE [dbo].[Vehicle]  WITH CHECK ADD  CONSTRAINT [FK_Vehicle_Vehicle_Type] FOREIGN KEY([ID_Vehicle_Type])
REFERENCES [dbo].[Vehicle_Type] ([ID_Vehicle_Type])
ALTER TABLE [dbo].[Vehicle] CHECK CONSTRAINT [FK_Vehicle_Vehicle_Type]
INSERT [dbo].[Customer] ([ID_Customer], [Name_Customer]) VALUES (1, N'Scott Willys')
INSERT [dbo].[Customer] ([ID_Customer], [Name_Customer]) VALUES (2, N'Jason Starter')
INSERT [dbo].[Customer] ([ID_Customer], [Name_Customer]) VALUES (3, N'Mike Fence')
INSERT [dbo].[Customer] ([ID_Customer], [Name_Customer]) VALUES (4, N'Jane Doe')
INSERT [dbo].[Customer] ([ID_Customer], [Name_Customer]) VALUES (5, N'Monroe Miller')
INSERT [dbo].[Customer] ([ID_Customer], [Name_Customer]) VALUES (6, N'Mary Key')
INSERT [dbo].[Customer] ([ID_Customer], [Name_Customer]) VALUES (7, N'Alicia Chambler')
INSERT [dbo].[Customer] ([ID_Customer], [Name_Customer]) VALUES (8, N'Joseph Climber')

INSERT [dbo].[Vehicle_Type] ([ID_Vehicle_Type], [Name_Vehicle_Type]) VALUES (1, N'Car')
INSERT [dbo].[Vehicle_Type] ([ID_Vehicle_Type], [Name_Vehicle_Type]) VALUES (2, N'Truck')
INSERT [dbo].[Vehicle_Type] ([ID_Vehicle_Type], [Name_Vehicle_Type]) VALUES (3, N'Motorcycle')

INSERT [dbo].[Vehicle] ([ID_Vehicle], [ID_Customer], [ID_Vehicle_Type], [Sell_Date], [Vehicle_Model], [Sell_Price]) VALUES (32, 4, 1, CAST(N'2023-02-06' AS Date), N'2018 Honda Civic', CAST(18000.00 AS Decimal(12, 2)))
INSERT [dbo].[Vehicle] ([ID_Vehicle], [ID_Customer], [ID_Vehicle_Type], [Sell_Date], [Vehicle_Model], [Sell_Price]) VALUES (33, 4, 1, CAST(N'2023-02-25' AS Date), N'2018 Toyota Corolla', CAST(35000.00 AS Decimal(12, 2)))
INSERT [dbo].[Vehicle] ([ID_Vehicle], [ID_Customer], [ID_Vehicle_Type], [Sell_Date], [Vehicle_Model], [Sell_Price]) VALUES (34, 4, 2, CAST(N'2023-02-16' AS Date), N'2017 Scania', CAST(180000.00 AS Decimal(12, 2)))
INSERT [dbo].[Vehicle] ([ID_Vehicle], [ID_Customer], [ID_Vehicle_Type], [Sell_Date], [Vehicle_Model], [Sell_Price]) VALUES (35, 4, 2, CAST(N'2023-02-27' AS Date), N'2021 Peterbuilt 589', CAST(200000.00 AS Decimal(12, 2)))
INSERT [dbo].[Vehicle] ([ID_Vehicle], [ID_Customer], [ID_Vehicle_Type], [Sell_Date], [Vehicle_Model], [Sell_Price]) VALUES (36, 4, 1, CAST(N'2023-04-05' AS Date), N'2015 VW Touareg', CAST(15000.00 AS Decimal(12, 2)))
INSERT [dbo].[Vehicle] ([ID_Vehicle], [ID_Customer], [ID_Vehicle_Type], [Sell_Date], [Vehicle_Model], [Sell_Price]) VALUES (37, 4, 1, CAST(N'2023-04-23' AS Date), N'2017 Nissan Versa', CAST(12000.00 AS Decimal(12, 2)))
INSERT [dbo].[Vehicle] ([ID_Vehicle], [ID_Customer], [ID_Vehicle_Type], [Sell_Date], [Vehicle_Model], [Sell_Price]) VALUES (38, 4, 2, CAST(N'2023-04-11' AS Date), N'2017 Ford F-450', CAST(57990.00 AS Decimal(12, 2)))
INSERT [dbo].[Vehicle] ([ID_Vehicle], [ID_Customer], [ID_Vehicle_Type], [Sell_Date], [Vehicle_Model], [Sell_Price]) VALUES (39, 4, 2, CAST(N'2023-04-27' AS Date), N'2021 RAM 2500', CAST(80000.00 AS Decimal(12, 2)))
INSERT [dbo].[Vehicle] ([ID_Vehicle], [ID_Customer], [ID_Vehicle_Type], [Sell_Date], [Vehicle_Model], [Sell_Price]) VALUES (40, 4, 3, CAST(N'2023-03-15' AS Date), N'2016 Yamaha R3', CAST(5000.00 AS Decimal(12, 2)))
INSERT [dbo].[Vehicle] ([ID_Vehicle], [ID_Customer], [ID_Vehicle_Type], [Sell_Date], [Vehicle_Model], [Sell_Price]) VALUES (41, 3, 1, CAST(N'2023-06-23' AS Date), N'2018 Honda Civic Type R', CAST(60500.00 AS Decimal(12, 2)))
INSERT [dbo].[Vehicle] ([ID_Vehicle], [ID_Customer], [ID_Vehicle_Type], [Sell_Date], [Vehicle_Model], [Sell_Price]) VALUES (42, 3, 1, CAST(N'2023-06-25' AS Date), N'2015 Smart ForTwo', CAST(15000.00 AS Decimal(12, 2)))
INSERT [dbo].[Vehicle] ([ID_Vehicle], [ID_Customer], [ID_Vehicle_Type], [Sell_Date], [Vehicle_Model], [Sell_Price]) VALUES (43, 3, 1, CAST(N'2023-06-12' AS Date), N'2018 Honda Civic', CAST(18000.00 AS Decimal(12, 2)))
INSERT [dbo].[Vehicle] ([ID_Vehicle], [ID_Customer], [ID_Vehicle_Type], [Sell_Date], [Vehicle_Model], [Sell_Price]) VALUES (44, 3, 2, CAST(N'2023-06-02' AS Date), N'2021 Peterbuilt 567', CAST(150000.00 AS Decimal(12, 2)))
INSERT [dbo].[Vehicle] ([ID_Vehicle], [ID_Customer], [ID_Vehicle_Type], [Sell_Date], [Vehicle_Model], [Sell_Price]) VALUES (45, 3, 2, CAST(N'2023-06-13' AS Date), N'2014 Peterbuilt 569', CAST(180000.00 AS Decimal(12, 2)))
INSERT [dbo].[Vehicle] ([ID_Vehicle], [ID_Customer], [ID_Vehicle_Type], [Sell_Date], [Vehicle_Model], [Sell_Price]) VALUES (46, 2, 1, CAST(N'2023-05-23' AS Date), N'2017 Nissan Versa', CAST(12000.00 AS Decimal(12, 2)))
INSERT [dbo].[Vehicle] ([ID_Vehicle], [ID_Customer], [ID_Vehicle_Type], [Sell_Date], [Vehicle_Model], [Sell_Price]) VALUES (47, 2, 1, CAST(N'2023-05-23' AS Date), N'2018 Honda Civic Type R', CAST(60500.00 AS Decimal(12, 2)))
INSERT [dbo].[Vehicle] ([ID_Vehicle], [ID_Customer], [ID_Vehicle_Type], [Sell_Date], [Vehicle_Model], [Sell_Price]) VALUES (48, 2, 2, CAST(N'2023-05-02' AS Date), N'2021 Peterbuilt 567', CAST(150000.00 AS Decimal(12, 2)))
INSERT [dbo].[Vehicle] ([ID_Vehicle], [ID_Customer], [ID_Vehicle_Type], [Sell_Date], [Vehicle_Model], [Sell_Price]) VALUES (49, 2, 2, CAST(N'2023-05-13' AS Date), N'2014 Peterbuilt 569', CAST(180000.00 AS Decimal(12, 2)))
INSERT [dbo].[Vehicle] ([ID_Vehicle], [ID_Customer], [ID_Vehicle_Type], [Sell_Date], [Vehicle_Model], [Sell_Price]) VALUES (50, 2, 1, CAST(N'2023-08-05' AS Date), N'2018 VW Touareg', CAST(25000.00 AS Decimal(12, 2)))
INSERT [dbo].[Vehicle] ([ID_Vehicle], [ID_Customer], [ID_Vehicle_Type], [Sell_Date], [Vehicle_Model], [Sell_Price]) VALUES (51, 2, 2, CAST(N'2023-08-11' AS Date), N'2017 Ford F-450', CAST(57990.00 AS Decimal(12, 2)))
INSERT [dbo].[Vehicle] ([ID_Vehicle], [ID_Customer], [ID_Vehicle_Type], [Sell_Date], [Vehicle_Model], [Sell_Price]) VALUES (52, 2, 3, CAST(N'2023-07-20' AS Date), N'2018 Honda Africa Twin', CAST(10000.00 AS Decimal(12, 2)))
32 rows affected

-- Query that isn't working as I wish
SELECT c.Name_Customer AS 'Customer', FORMAT(v.Sell_Date, 'M/yyyy') AS 'Period',
CASE 
	WHEN t.Name_Vehicle_Type = 'Car' THEN (COUNT(distinct v.ID_Vehicle)) ELSE NULL END AS 'Cars quantity',
CASE
	WHEN t.Name_Vehicle_Type = 'Car' THEN SUM(distinct v.Sell_Price) ELSE NULL END AS 'Cars total price',
CASE 
	WHEN t.Name_Vehicle_Type = 'Truck' THEN (COUNT(distinct v.ID_Vehicle)) ELSE NULL END AS 'Trucks quantity',
CASE
	WHEN t.Name_Vehicle_Type = 'Truck' THEN SUM(distinct v.Sell_Price) ELSE NULL END AS 'Trucks total price'
FROM Customer AS c, Vehicle AS v, Vehicle_Type AS t
WHERE c.ID_Customer = v.ID_Customer and v.ID_Vehicle_Type = t.ID_Vehicle_Type
GROUP BY v.ID_Customer, FORMAT(v.Sell_Date, 'M/yyyy'), c.Name_Customer, v.ID_Customer, t.Name_Vehicle_Type
HAVING (t.Name_Vehicle_Type = 'Car' or t.Name_Vehicle_Type = 'Truck')
ORDER BY c.Name_Customer, 'Period'


Customer
Period
Cars quantity
Cars total price
Trucks quantity
Trucks total price


Jane Doe
2/2023
2
53000.00
null
null

Jane Doe
2/2023
null
null
2
380000.00

Jane Doe
4/2023
2
27000.00
null
null

Jane Doe
4/2023
null
null
2
137990.00

Jason Starter
5/2023
2
72500.00
null
null

Jason Starter
5/2023
null
null
2
330000.00

Jason Starter
8/2023
1
25000.00
null
null

Jason Starter
8/2023
null
null
1
57990.00

Mike Fence
6/2023
3
93500.00
null
null

Mike Fence
6/2023
null
null
2
330000.00
Customer	Period	Cars quantity	Cars total price	Trucks quantity	Trucks total price
Jane Doe	2/2023	2	53000.00	null	null
Jane Doe	2/2023	null	null	2	380000.00
Jane Doe	4/2023	2	27000.00	null	null
Jane Doe	4/2023	null	null	2	137990.00
Jason Starter	5/2023	2	72500.00	null	null
Jason Starter	5/2023	null	null	2	330000.00
Jason Starter	8/2023	1	25000.00	null	null
Jason Starter	8/2023	null	null	1	57990.00
Mike Fence	6/2023	3	93500.00	null	null
Mike Fence	6/2023	null	null	2	330000.00