Types of JOINs

There is an online store where people can order some groceries. It has a database consisting of three tables that contain all the data about the orders:

• users (id INT, email VARCHAR(50))
• groceries (id INT, name VARCHAR(50))
• orders (user_id INT, grocery_id INT)

Write a query that returns all groceries (name) ordered by a particular user (email). The order of rows is not important.