Table: us_jewish_areas
Columns: rank_wjc
rank_arda
metro_area
number_of_jews_wjc
number_of_jews_asarb

Question: What is the rank where the area is Los Angeles?
SQL: SELECT "rank_wjc" FROM us_jewish_areas WHERE "metro_area" = 'Los Angeles'

Question: What is the number of jews where the rank is 1?
SQL: SELECT COUNT("number_of_jews_wjc") FROM us_jewish_areas WHERE "rank_arda" = 1

Question: What is the number of jews asarb where the metro area is philadelphia?
SQL: SELECT "number_of_jews_asarb" FROM us_jewish_areas WHERE "metro_area" = 'Philadelphia'