To check the prediction accuracy:
SELECT (SELECT count(id) FROM svm_iris_predict_out WHERE predict_value = species)/( SELECT count(id) FROM svm_iris_predict_out) AS prediction_accuracy;
prediction_accuracy |
---|
0.86666666666666666667 |
To check the prediction accuracy:
SELECT (SELECT count(id) FROM svm_iris_predict_out WHERE predict_value = species)/( SELECT count(id) FROM svm_iris_predict_out) AS prediction_accuracy;
prediction_accuracy |
---|
0.86666666666666666667 |