SELECT cities.zip_code, cities.city, cities.state_code, customers.last_name, customers.first_name
FROM Data Twin Project ID.customer_dataset.customer_info as customers
JOIN Data Publisher Project ID.data_publisher_dataset.authorized_view as cities
ON cities.state_code = customers.state; SELECT * FROM (
SELECT *, ROW_NUMBER() OVER (PARTITION BY state_code ORDER BY area_land_meters DESC) AS cities_by_area
FROM bigquery-public-data.geo_us_boundaries.zip_codes) cities
WHERE cities_by_area <= 10 ORDER BY cities.state_code
LIMIT 1000;