Database: dorm_1
Question: How many different majors are there and how many different city codes are there for each student?
SQL:
SELECT count(DISTINCT major) ,  count(DISTINCT city_code) FROM student