Need help creating a simple logic in SQL -- 2

Job ID: 33800630

Budget: $10 – $30 USD

I have CURRENT_TABLE.jpg and I need to create logic in SQL that can increment values based on condition
Related categories: SQL MySQL Microsoft SQL Server