Database: dorm_1
Question: Find the numbers of different majors and cities.
SQL:
SELECT count(DISTINCT major) ,  count(DISTINCT city_code) FROM student