SQLKATA-The Bookwarm's Haven Inventory System

Question No : 3

The store decides to apply a 10% discount to all books published before 1950. Can you update the prices and then display the titles, original prices, and new prices of the affected books?

My Answer :

SELECT title, price , ROUND(price * 0.9,2) AS new_price

FROM books

WHERE publication_year < 1950

ORDER BY publication_year ASC;

I also tried Orderby (DESC) and the alias name variations ...etc

But, I cant able to found out the exact error / the solution compiler Expects.

Can Anyone Help me with this !?

============================================================

I'm really happy about this new SQLKATA feature! Honestly, just two days ago, I was thinking how great it would be if this existed, and now it's here—I'm so excited!

Also, I think it would be even better if there was a way to show errors clearly in this feature. 😊