Introduction
2. The Recipe table
Quiz
Congratulations

Instruction

We will start with very easy exercises.

But before you begin writing code, first look at the data on which you will operate. On the right side of the screen, there is a button labeled Database – click on 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 you will operate on is the Recipe table. This table contains a set of recipes for various dishes (foods).

Exercise

Select all the data from the Recipe table. It has the columns:

  • Id – the identifier of the recipe.
  • Name – the name of the recipe.
  • Difficulty – the difficulty of the recipe, from 1 to 3. A 3 indicates the most difficult, and a 1 – the least.
  • CookTime – the time (in minutes) to make the recipe.
  • Rating – the number of points (from 1 to 3) given by people as an assessment of that recipe. A 3 is excellent, the highest mark, and a 1 – not so good, the lowest mark.