Veritabanını oluşturup test ettim hocam çalışıyor, hayırlı sahurlar

Select a.adet * c.price as tutar From (
Select Top 1
max(product) as product,
count(*) as adet ,
ROW_NUMBER() OVER (ORDER BY count(*) desc) as row
from soldProducts
group by product
order by count(*) desc) As a
inner join product as b on a.product = b.productId
inner join productInformation as c on c.productInformationID = b.productInformationID