验证中...
Languages: SQL
Categories: 数据库相关
Latest update 2019-03-19 10:16
hq_question_select.txt
Raw Copy
SELECT
q.HOSPITALNAME as 所属医院,
CASE q.OBJECTTYPE
WHEN 'Patient' THEN '患者'
WHEN 'PatientFamily' THEN '患者家属'
WHEN 'Doctor' THEN '医生'
WHEN 'Nurse' THEN '护士'
WHEN 'MedicalTechnician' THEN '医技人员'
WHEN 'Management' THEN '管理人员' ELSE '其他'
END 调查对象,
CASE q.SEX
WHEN 'male' THEN '男'
WHEN 'female' THEN '女'
END 性别,
CASE q.AGEFIELD
WHEN 1 THEN '18岁以下'
WHEN 2 THEN '18~30'
WHEN 3 THEN '30~40'
WHEN 4 THEN '40~50'
WHEN 5 THEN '50~60'
WHEN 6 THEN '60岁以上'
END 年龄段,
q.QUALITYINDOOR as 室内环境质量,
q.qualityOutdoor as 室外环境质量,
q.toiletHygiene as 厕所卫生状况,
q.cleanService as 保洁服务态度,
q.dailySecurity as 日常安保工作,
q.accidentalDisposal as 意外处置及时性,
q.securityService as 安保服务态度,
q.dishPrice as 菜品价格,
q.diningEnvironment as 就餐环境,
q.foodService as 餐饮服务态度,
q.deliveryTimeliness as 送餐的及时性,
q.foodNutrition as 餐品口味营养,
q.diningAttitude as 送餐服务态度,
q.transportTimeliness as 运送及时性,
q.transportAccuracy as 运送准确性,
q.transportService as 运送服务态度,
q.repairTimeliness as 维修及时性,
q.repairQuality as 维修质量,
q.elevatorStatus as 电梯运状态,
q.operationService as 运维服务态度,
q.suggest as 建议
FROM HP_QUESTION q
WHERE q.HOSPITALNAME = 'XH'

Comment list( 0 )

You need to Sign in for post a comment

Help Search