rt4

-- Q1
SELECT count(*) FROM employee AS e WHERE e.sex = 'F';

-- Q2

SELECT AVG(e.salary) FROM employee AS e WHERE e.sex = 'M' AND e.address LIKE '%TX';

-- Q3

SELECT e.superssn, count(*) FROM employee AS e GROUP BY e.superssn ORDER BY COUNT(*);

-- Q4

SELECT e.fname, count(e.fname) FROM employee AS e, employee AS ee WHERE e.ssn = ee.superssn GROUP BY e.fname ORDER BY count(*), e.fname;