• I knew my table design is silly.

    To built column name and data, see below:-

    1- Answer-Staff (9) is a DeclarationQuestionID=9 and Column is Answer

    2- Response-Staff (9) is a DeclarationQuestionID=9 and Column is Response

    3- Answer-Disease (2) is a DeclarationQuestionID=2 and Column is Answer

    4- Response-Physical (2) is a DeclarationQuestionID=2 and Column is Response

    I've no idea how is SQL looks like