| id | name     |
| 1  | andrea   |
| 2  | marco    |
| 3  | giovanni |

| id | name_id | date |
| 1  | 1       | 5000 |
| 2  | 1       | 4000 |
| 3  | 2       | 1500 |
| 4  | 2       | 3000 |
| 5  | 2       | 1000 |
| 6  | 3       | 6000 |
| 7  | 3       | 2000 |

SELECT * FROM customers LEFT JOIN access ON customers.id =
access.name_id

SELECT * FROM customers LEFT JOIN access ON customers.id =
access.name_id GROUP BY customers.id