Table: law_firms_rank
Columns: rank
largest_u_s_city
total
partners
other

Question: What is the average number of partners for the firm with a rank under 71, other over 77, and largest city of Philadelphia?
SQL: SELECT AVG("partners") FROM law_firms_rank WHERE "rank" < 71 AND "largest_u_s_city" = 'philadelphia' AND "other" > 77

Question: What is the smallest rank for the city having partners of 342, other under 147, and largest city of Cleveland?
SQL: SELECT MIN("rank") FROM law_firms_rank WHERE "partners" = 342 AND "largest_u_s_city" = 'cleveland' AND "other" < 147

Question: What is the number of partners for the city ranked under 294, total over 264, largest city of Chicago, and other over 46?
SQL: SELECT "partners" FROM law_firms_rank WHERE "rank" < 294 AND "total" > 264 AND "largest_u_s_city" = 'chicago' AND "other" > 46