In SQL im trying to table a column and add to it's value and then take that value and add it to another column

im trying to take items.unit_price, increase it's value by 10% inside a subquery and then display it in another column

Here is my code

select items.title, items.unit_price, items.unit_price as Price_increase
from artists
join items
on items.artist_id = artists.artist_id
order by price_increase in
(
    select distinct round(items.unit_price + (items.unit_price * 0.1), 2) as Price_increase
    from artists
    where artists.artist_name = "No Rest For The Weary"
)
;

Any help would be greatly appreciated