Write a SQL query

Job ID: 31166643

Budget: $10 – $30 USD

I want to create a new table using an exisiting old table and add new columns to the new table based on certain conditions from the old table.