It's Autumn! Prices fall like leaves! - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
2. Recipe table
Quiz
Congratulations

Instruction

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).

Exercise

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).