Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
2. Recipe table


We will start with very easy exercises. But before you begin writing code, first look at the tables on which you will operate. On the right side of the screen, there is a button labeled Database – click it to study the structure of the tables.

Some of us collect recipes for our favorite meals. Our database stores a collection of recipes for a favorite meal.

The first table is the recipe table. This table contains a set of recipes for various dishes (foods).


Select all data from the recipe table. It has the following columns:

  • id – A unique identifier for each recipe.
  • name – The name of the recipe.
  • difficulty – Recipes have varying difficulty levels: 3 indicates the most difficult, 1 indicates the easiest.
  • cook_time – Time, in minutes, to make the recipe.
  • rating – An assessment of the recipe, given as a number from 1 (not so good) to 3 (excellent).