create table tblViewedtimes (CustomerID int, ProductID int, ViewedTime varchar(31));

create table tblProducts (ProductID int, ProductName varchar(31), SellerId int, ClosingTime varchar(31));

create table tblSellers (SellerId int, SellerName varchar(31));

insert into tblContactedtimes values

(2, 3223, 26, '2024-06-06 20:37:11.6200000'),

(3, 2492, 24, '2024-06-10 05:25:43.1800000'),

(3, 2492, 24, '2024-06-10 05:28:06.7000000'),

(7, 2567, 21, '2024-06-10 22:10:50.3033333'),

(7, 3267, 21, '2024-06-11 05:28:08.4600000'),

(3, 3175, 24, '2024-06-12 20:00:07.4166667');

insert into tblViewedtimes values

(2601, 20, '2024-05-09 18:56:05.7366667'),

(2468, 12, '2024-05-09 19:18:46.2100000'),

(2133, 21, '2024-05-09 20:44:41.6166667'),

(3036, 22, '2024-05-09 21:38:54.3400000'),

(2019, 22, '2024-05-09 21:44:22.7200000'),

(2507, 26, '2024-05-05 19:03:14.6633333'),

(3036, 24, '2024-05-09 21:38:54.3400000');

insert into tblProducts values

(20, 'ProdName 20', 2, '2025-06-06 20:37:11.6200000'),

(12, 'ProdName 12', 3, '2026-05-09 18:56:05.7366667'),

(21, 'ProdName 21', 7, '2025-06-06 20:37:11.6200000'),

(22, 'ProdName 22', 7, '2026-05-09 18:56:05.7366667'),

(24, 'ProdName 24', 3, '2025-06-06 20:37:11.6200000'),

(26, 'ProdName 26', 2, '2026-05-09 18:56:05.7366667');

insert into tblSellers values

(2, 'Seller 2'),

(3, 'Seller 3'),

(7, 'Seller 7');

ProductName, SellerName,

(select count(1) from tblViewedtimes v where v.ProductID = p.ProductID) [Count of Product Views],

(select count(1) from tblContactedtimes c where c.ProductID = p.ProductID) [Count of Product Contacted]