<s>[INST] I have two tables in a MySQL database, `users` and `orders`. The `users` table has a column called `email` and the `orders` table has a column called `user_id`. I would like to find the number of orders for each user, where the orders have a specific status (let's say "pending").

Here's an example of the `users` table

| id | email |
|----|-------|
| 1  | a@b.c |
| 2  | d@e.f |
| 3  | g@h.i |

And here's an example of the `orders` table

| id | user_id | status |
|----|---------|--------|
| 1  | 1       | new    |
| 2  | 1       | pending|
| 3  | 2       | pending|
| 4  | 1       | pending|
| 5  | 1       | new    |

What query can I use to get the number of pending orders for each user?[/INST]