SELECT s.name AS stadium_name,
       ROUND(3.14159265358979 * (s.diameter_of_the_stadium / 2.0) * (s.diameter_of_the_stadium / 2.0), 1) AS stadium_area
FROM stadiums s
JOIN locations l ON s.location_id = l.location_id
WHERE l.name IN ('California', 'Newyork')
ORDER BY stadium_area DESC, stadium_name ASC;