SELECT count(DISTINCT major) ,  count(DISTINCT city_code) FROM student
How many different majors are there and how many different city codes are there for each student?
SELECT count ( DISTINCT major ) , count ( DISTINCT city_code ) FROM student
select count ( distinct major ) , count ( distinct city_code ) from student
How many different majors are there and how many different city codes are there for each student ?