mysql> select gender from students group by gender;
SQL = "select gender, sum(english), avg(math), count(*) from students group by gender"
df = pd.read_sql(SQL, db)
df
gender | sum(english) | avg(math) | count(*) | |
---|---|---|---|---|
0 | man | 278.0 | 63.75 | 4 |
1 | woman | 193.0 | 60.00 | 3 |
SQL = "select gender, max(english), min(math) from students group by gender"
df = pd.read_sql(SQL, db)
df
gender | max(english) | min(math) | |
---|---|---|---|
0 | man | 90 | 32 |
1 | woman | 87 | 30 |
SQL = "select gender, avg(english), avg(math), avg(korean) from students group by gender"
df = pd.read_sql(SQL, db)
df
gender | avg(english) | avg(math) | avg(korean) | |
---|---|---|---|---|
0 | man | 69.5000 | 63.75 | 52.7500 |
1 | woman | 64.3333 | 60.00 | 70.3333 |
SQL = "select gender, min(english), min(math), min(korean) from students group by gender"
df = pd.read_sql(SQL, db)
df
gender | min(english) | min(math) | min(korean) | |
---|---|---|---|---|
0 | man | 45 | 32 | 20 |
1 | woman | 30 | 30 | 60 |
SQL = "SELECT DISTINCT gender FROM students"
df = pd.read_sql(SQL, db)
df
gender | |
---|---|
0 | man |
1 | woman |