php - Combining multiple queries into an output

Question

With a feedback survey they can select bad, neutral or good. I want to compile the bad and good into a table. I am trying to create a tally "table" output from an ajax request to replace a div content. Ideally it will look like:

Experience	Negative	Positive
Cleanliness	12	18
Check-In/Out	4	30
Food	2	12
Staff	1	8

question from:https://stackoverflow.com/questions/65941124/combining-multiple-queries-into-an-output

Answer 1

You could obtain the table using a single UNION query

SELECT 'staff', COUNT(IF(`staff` = 'negative', 1, NULL)) negative, COUNT(IF(`staff` = 'positive', 1, NULL)) positive
FROM responses 
UNION 
SELECT 'cleanliness', COUNT(IF(`cleanliness` = 'negative', 1, NULL)) negative, COUNT(IF(`cleanliness` = 'positive', 1, NULL)) positive
FROM responses 
UNION 

SELECT 'food', COUNT(IF(`food` = 'negative', 1, NULL)) negative, COUNT(IF(`food` = 'positive', 1, NULL)) positive
FROM responses 
UNION
SELECT 'check-in/out', COUNT(IF(`check-in/out` = 'negative', 1, NULL)) negative, COUNT(IF(`check-in/out` = 'positive', 1, NULL)) positive
FROM responses