SQL Query Help

Job ID: 36416827

Budget: $10 – $11 USD

I am looking for a freelancer who can help me create a MySQL query for data retrieval. The ideal candidate should have experience and skills in MySQL and query creation. The project involves the following:

-to Remove such Characters from ID For an example ID = IG.1234567-1, ID = IG.1234567-1-BC in this example there is a -BC at last so dont consider -BC ID and -1-BC iD bcoz -BC is billing canceled like that
- And Also Helps in SQL join As well Query

If you have experience in MySQL and query creation, please apply for this project.