with temptbl as (SELECT ROW_NUMBER() OVER (order by ProductID)AS Row, * from Products)SELECT * FROM temptbl w…