SELECT Sex, COUNT(*) FROM employee WHERE Salary < 50000 GROUP BY Sex
Find the number of employees of each gender whose salary is lower than 50000. Show a pie chart.
CREATE TABLE works_on (
    Essn INTEGER,
    Pno INTEGER,
    Hours REAL
)

CREATE TABLE dependent (
    Essn INTEGER,
    Dependent_name TEXT,
    Sex TEXT,
    Bdate TEXT,
    Relationship TEXT
)

CREATE TABLE project (
    Pname Text,
    Pnumber INTEGER,
    Plocation TEXT,
    Dnum INTEGER
)

CREATE TABLE employee (
    Fname TEXT,
    Minit TEXT,
    Lname TEXT,
    Ssn INTEGER,
    Bdate TEXT,
    Address TEXT,
    Sex TEXT,
    Salary INTEGER,
    Super_ssn INTEGER,
    Dno INTEGER
)

CREATE TABLE department (
    Dname TEXT,
    Dnumber INTEGER,
    Mgr_ssn INTEGER,
    Mgr_start_date TEXT
)

CREATE TABLE dept_locations (
    Dnumber INTEGER,
    Dlocation TEXT
)