I had to normalize data first and then move on with sub-questions by writing SQL queries.
How do I do the data normalization itself in MYSQL?
My other (sub-question) queries were correct.
The column that I have to normalize is water_source. I can use substring_index() but even though tried and tested I couldn’t get the result. I have to split column values into rows.
table
I tried and tested several queries but couldn’t find any.
New contributor
Anamika is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2