Code: Select all
SELECT
Person_ID.Person_Name, Person_Skill.Skill_name, Person_Skill.Score, ID_Table.Weight, (Person_Skill.Score-ID_Table.Weight) AS total,sum(ID_Table.Weight) AS sumweight,SUM(Person_Skill.Score) AS sumscore, Job_ID.Job_Name, ID_Table.Skill_Name
FROM
Job_ID
JOIN ID_Table
USING (Job_ID)
JOIN Person_Skill
USING (Skill_Name)
JOIN Person_ID
USING (Person_ID)
WHERE Person_Skill.Skill_Name='Nish'
ORDER BY
total
DESC
Thanks