select gender, ethnicity, count(id) as num_senators from us_senate group by gender,ethnicity order by num_senators desc;
select gender, ethnicity, count(id) as num_senators from us_senate group by gender,ethnicity order by num_senators desc;
select gender, ethnicity, count(id) as num_senators from us_senate group by gender,ethnicity order by num_senators desc;
select gender, ethnicity, count(id) as num_senators from us_senate group by gender,ethnicity order by num_senators desc;
select gender, ethnicity, count(id) as num_senators from us_senate group by gender,ethnicity order by num_senators desc;
select gender, ethnicity, count(*) as num_senators from us_senate group by gender, ethnicity order by num_senators desc;
select gender,ethnicity, count(*) as num_senators from us_senate group by gender, ethnicity order by count(*) desc;
select gender,ethnicity, count(*) as num_senators from us_senate group by gender, ethnicity order by count(*) desc;
SELECT gender, ethnicity, COUNT(*) AS 'num_senators' FROM us_senate GROUP BY gender, ethnicity;
SELECT gender, ethnicity, COUNT(*) AS 'num_senators' FROM us_senate GROUP BY gender, ethnicity;
SELECT gender, ethnicity, COUNT(*) AS num_senators FROM us_senate uss GROUP BY gender, ethnicity ORDER BY COUNT(*) DESC;
SELECT gender, ethnicity, count(*) num_senators FROM us_senate GROUP BY gender, ethnicity;
select gender, ethnicity , count(*) as num_senators from us_senate group by gender, ethnicity;
select gender, ethnicity , count(*) as num_senators from us_senate group by gender, ethnicity;
select gender, ethnicity, count(*) as num_senators from us_senate group by gender, ethnicity order by num_senators desc;
select gender, ethnicity, count(*) as num_senators from us_senate group by gender, ethnicity order by num_senators desc;
select gender, ethnicity, count(*) as num_senators from us_senate group by gender, ethnicity order by num_senators desc;