Volunteering

Create Table

                CREATE TABLE tblEffects (
                    pmkEffectsId INT AUTO_INCREMENT PRIMARY KEY,
                    fldAge VARCHAR(22)
                    fldEnriched VARCHAR(10),
                    fldEmployment VARCHAR(5),
                    fldProportion VARCHAR(5)
                )

                INSERT INTO tblEffects VALUES
                ('Young Volunteers','✓','+27%','28.2%'),
                ('Retired Volunteers','✓','+27%','40%'),
                ('Non-Volunteers','X','+0%','0%')

                SELECT fldAge, fldEnriched, fldEmployment, fldProportion FROM tblEffects

                CREATE TABLE tblSurvey (
                    pmksurveyID INT AUTO_INCREMENT PRIMARY KEY,
                    fldPhysLabor TINYINT(1),
                    fldNearCharity TINYINT(1),
                    fldOrgPassion TINYINT(1),
                    fldAge VARCHAR(8),
                    fldActivity VARCHAR(20),
                    fldEmail VARCHAR(50)
                )

                INSERT INTO tblSurvey(pmkSurveyId, fldPhysLabor, fldNearCharity, fldOrgPassion, fldAge, fldActivity)
                VALUES (1, 0, 0, 0, 'Young', 'Making Food')