So let's say I'm creating a polygon table taking attributes from multiple polygon tables. For argument's sake let's say one is a country polygon table and one is a mountain table
On my mountain table I have the Alps, and I want to give it the country in which the Alps is covered by the most
create table as select a.id, a.mountain, b.country from mountaintable a, countrytable b where st_intersects???
How to make it return the needed result?