Hello (0)
WordPress database error: [Unknown column 's.employee_name' in 'field list']
SELECT
s.employee_name
FROM ey3_surveys AS s
WHERE 1=1
AND (s.manager_id = 0
OR s.company_id = 0
OR s.training_company_id = 0
OR s.trainer_id = 0 )
ORDER BY s.employee_name
WordPress database error: [Unknown column 's.manager_id' in 'where clause']
SELECT
q.question,
sum(q.answer_before) as before_ct,
sum(q.answer_after) as after_ct
FROM ey3_surveys s JOIN ey3_survey_questions q ON q.survey_id = s.id
WHERE q.answer in ('1','2','3','4','5')
AND (s.manager_id = 0
OR s.company_id = 0
OR s.training_company_id = 0
OR s.trainer_id = 0 )
GROUP BY q.question
ORDER BY q.question
Team Results
| Topic | Average Before | Average After |
WordPress database error: [Unknown column 's.employee_name' in 'field list']
SELECT
s.employee_name,
count(q.answer_before) as before_no,
count(q.answer_after) as after_no,
sum(q.answer_before) as before_ct,
sum(q.answer_after) as after_ct
FROM ey3_surveys s JOIN ey3_survey_questions q ON q.survey_id = s.id
WHERE q.answer in ('1','2','3','4','5')
AND (s.manager_id = 0
OR s.company_id = 0
OR s.training_company_id = 0
OR s.trainer_id = 0 )
GROUP BY s.employee_name
ORDER BY s.employee_name
WordPress database error: [Unknown column 's.employee_name' in 'field list']
SELECT
q.question,
s.employee_name,
sum(q.answer_before) as before_ct,
sum(q.answer_after) as after_ct
FROM ey3_surveys s JOIN ey3_survey_questions q ON q.survey_id = s.id
WHERE q.answer in ('1','2','3','4','5')
AND (s.manager_id = 0
OR s.company_id = 0
OR s.training_company_id = 0
OR s.trainer_id = 0 )
GROUP BY q.question,s.employee_name
ORDER BY q.question,s.employee_name
| Name | Average Before | Average After | Change |
WordPress database error: [Unknown column 's.employee_name' in 'field list']
SELECT
s.employee_name,
count(q.answer_before) as before_no,
count(q.answer_after) as after_no,
sum(q.answer_before) as before_ct,
sum(q.answer_after) as after_ct
FROM ey3_surveys s JOIN ey3_survey_questions q ON q.survey_id = s.id
WHERE q.answer in ('1','2','3','4','5')
AND (s.manager_id = 0
OR s.company_id = 0
OR s.training_company_id = 0
OR s.trainer_id = 0 )
GROUP BY s.employee_name
ORDER BY s.employee_name
WordPress database error: [Unknown column 's.manager_id' in 'where clause']
SELECT
q.question,
sum(q.answer_before) as before_ct,
sum(q.answer_after) as after_ct
FROM ey3_surveys s JOIN ey3_survey_questions q ON q.survey_id = s.id
WHERE q.answer in ('1','2','3','4','5')
AND (s.manager_id = 0
OR s.company_id = 0
OR s.training_company_id = 0
OR s.trainer_id = 0 )
GROUP BY q.question