Retrieve from 4 SQL tables with two count/group by values?

I have 4 tables tblProducts, tblSellers, tblViewedtimes, tblContactedtimes with below columns. How can we retrieve summary as below:

tblContactedtimes

tblViewedtimes

tblProducts

tblSellers

Is it possible to query below summary as it involves 2 count, along with where condition "Where tblProducts.ClosingTime > CurrentTime"?

Sample output

The simplest way of counting decorrelated items is to do this in subqueries:

select
    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]
from tblProducts p join tblSellers s on s.SellerId = p.SellerID;

which returns:

(see it in a fiddle)

If you want to correlate your data (e.g. get the percentage of views that result in a contact),
you'll prefer Common Table Expressions (CTE),
which will allow you to reuse the subselects multiple times (for example get the count as is + use it to compute a percentage).
But that's another story…