Great book!

WITH TEMP

AS

(

SELECT

row_number() over (order by book_id) as ID

,BOOK_DETAIL_ID

FROMBOOKS

)

SELECT *

FROM TEMP