Group by fk in two tables

[Pietje van der Pukje]

I would like to implement a query that returns the following result. Could anyone help with this?

Table: tickets
*Id | customer
1 | 1
2 | 1
3 | 2
4 | 3

Table: ticket_messages
id | *ticket_id | message
1 | 1 | message
2 | 1 | message
3. | 2 | message


Result
customer. | number_of_tickets | number_of_ticket_messages
1 | 2 | 2
2 | 1 | 1
3 | 1 | 0