We have approx 2250 formulas (to be used in SELECT statements) in SQL language. Some statements work automatically in MySQL but others do not, because of different syntax in MySQL.
Please convert the SQL formulas into MySQL language. Write a simple parser which changes SQL: "decode" to MySQL: "Case when..". Test all formulas in MySQL (test data included).
(Note: Range should be 0 - 600$ with maximum 800$. Apologies for confusion.)
**Main Deliverables expected from Coder:**
- Return [login to view URL] sheet with a column filled with MySQL formula.
- Code used for testing all formulas (one file which includes all formulas tests so that it can be run on our test data)
- Parser script with source code for converting formulas should be provided so that optXview can modify it or use it later if needed