CODEWITHSUNDEEP
mysql
David542
David542

Reputation: 110093

How to hide a column in mysql

Is there a way to 'hide' the percentage column in the following query?

SELECT 
    ((SUM(is_correct) / COUNT(*)) * 100) percentage, worker_id 
FROM 
    main_mturklog 
GROUP BY 
    worker_id HAVING percentage < 80

Basically, I only want to view the worker_id in the result.

Upvotes: 0

Views: 1809

Answers (1)

juergen d
juergen d

Reputation: 204746

SELECT 
    worker_id 
FROM 
    main_mturklog 
GROUP BY 
    worker_id 
HAVING ((SUM(is_correct) / COUNT(*)) * 100) < 80

Upvotes: 3

Related Questions