Answered by cyerrajodu

select gender,
       ethnicity,
       count(id) as num_senators
 from us_senate
 group by gender,ethnicity
 order by num_senators desc;

Answered by pamity

select gender, ethnicity, count(*) as num_senators 
from us_senate 
group by gender, ethnicity
order by num_senators desc;

Answered by trabi71

select gender,ethnicity, count(*) as num_senators
from us_senate 
group by gender, ethnicity
order by count(*) desc;

Answered by sbalema2

select gender,ethnicity, count(*) as num_senators
from us_senate 
group by gender, ethnicity
order by count(*) desc;

Answered by jengahguy

SELECT gender, ethnicity, COUNT(*) AS 'num_senators'
FROM us_senate
GROUP BY gender, ethnicity;

Answered by amkreiner

SELECT gender, ethnicity, COUNT(*) AS 'num_senators'
FROM us_senate
GROUP BY gender, ethnicity;

Answered by superhoops540

SELECT gender, ethnicity, COUNT(*) AS num_senators
FROM us_senate uss
GROUP BY gender, ethnicity
ORDER BY COUNT(*) DESC;

Answered by blep

SELECT gender, ethnicity, count(*) num_senators FROM us_senate GROUP BY gender, ethnicity;

Answered by sbw0125

select gender, ethnicity , count(*) as num_senators from us_senate 
group by gender, ethnicity;

Answered by diddyp20

select gender, ethnicity , count(*) as num_senators from us_senate 
group by gender, ethnicity;

Answered by parth

select gender, ethnicity, count(*) as num_senators 
	from us_senate group by gender, ethnicity
    order by num_senators desc;

Answered by anonymousUser

select gender, ethnicity, count(*) as num_senators 
	from us_senate group by gender, ethnicity
    order by num_senators desc;

Answered by jrz1977

select gender, ethnicity, count(*) as num_senators 
	from us_senate group by gender, ethnicity
    order by num_senators desc;