---

WITH title_sales AS (
SELECT title, buy_book.amount, price
FROM book
INNER JOIN buy_book USING(book_id)
INNER JOIN buy USING(buy_id)
INNER JOIN buy_step USING(buy_id)
INNER JOIN step USING(step_id)
WHERE date_step_end IS NOT NULL AND name_step = "Оплата"

UNION ALL

SELECT title, buy_archive.amount, buy_archive.price    
FROM buy_archive
INNER JOIN book USING(book_id)
)