Volunteering

A Comprehensive Guide on helping other people

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