0
I have a table in Mysql as follows and structure:
I would like to run an SQL query that does the following operations:
- Total number of records (total1);
- Count how many records have id_nps_answer between 0 and 6 (total2);
- Count how many records have id_nps_answer between 9 and 10 (total3);
- Perform the calculation ((total3 - total2) / total1);
The result would be made available to PHP.
Is that possible? I’m not getting the code.
worked. Thank you very much...
– Flávio Kowalske