How to write sql query?

Question

PostgreSQL

tell me how to write a SQL query (PostgreSQL)
there are 2 tables:
company(
1 name
2 events = many_to_many(event)
)
event (
1 name
)
1 linking table -
company_events (
1 id
2 company_id
3 event_id
)
how to write a sql query to output like this:
id |company name.| list of events separated by commas
id |company name.| list of events separated by commas
id |company name.| list of events separated by commas

Answer 1

select company.*, string_agg(events.name, ', ') from  company JOIN  company_events 
    ON company_events.company_id = company.id
JOIN  events
    ON events.id = company_events.event_id
GROUP BY company.id;