Generate Shopping List from Recipes

You are a chef preparing for an important event. You downloaded three recipes to make and imported each as a separate table: recipe1, recipe2, recipe3 into your database. Each recipe requires some grocery items in various quantities.

Write a query that sums up the total mass of each grocery item required across all recipes.

Input:

recipe1 table:

recipe2 table:

recipe3 table:

Output: