management information system and app
Mo7ammedaziz 
a03t1Survey.accdb| ID | Gender | IncomeLevel | PoliticalAffiliation | Question1 | Question2 | Question3 | Question4 | Question5 |
|---|---|---|---|---|---|---|---|---|
| 1 | Female | $100,000+ | Democrat | 3 | 3 | 3 | 1 | 3 |
| 2 | Male | $25,000 to $50,000 | Republican | 2 | 2 | 2 | 2 | 2 |
| 3 | Female | $50,000 to $100,000 | Independent | 3 | 3 | 1 | 3 | 1 |
| 4 | Female | $50,000 to $100,000 | Republican | 2 | 2 | 2 | 2 | 2 |
SELECT DISTINCTROW *
FROM [Survey Results];
SELECT [Survey Results].Gender, Count([Survey Results].ID) AS CountOfID, Avg([Survey Results].Question1) AS AvgOfQuestion1
FROM [Survey Results]
GROUP BY [Survey Results].Gender;
