could u help me with this. Please provide the sql query and explanation. Thanks

You have 3 tables. cities (id::int, name::varchar), assets(id::int, city_id::int, alias::varchar), owners (id::int, asset_id::int, full_name::varchar). Write a SQL query that will return a SINGLE row for each asset, including the city name, the alias, the number of owners, the list of owner names. The output should include only assets in cities that have more than 10 assets, regardless if they have owners or not. *