use the following code to create your own query that uses two FROM clauses :

Create table USERS$($

UserID int not null auto$\_$increment,

FirstName varchar$(255)$ not null,

LastName varchar$(255)$ not null,

SignIn date default $($curdate$()),$

Primary Key$($UserID$)$

$)$;

Create table RECIPE$($

RecipeID int not null auto$\_$increment,

UserID int not null,

Name varchar$(255)$ not null,

Published date default $($curdate$()),$

Primary Key$($RecipeID$),$

Foreign Key$($UserID$)$ references USERS$($UserID$)$ on delete cascade

$)$;

Create table RECIPE$\_$STEPS$($

RecipeID int not null,

Step int not null,

StepDescription varchar$(255)$ not null,

Primary Key$($RecipeID$,$ Step$),$

Foreign Key $($RecipeID$)$ references RECIPE$($RecipeID$)$ on delete cascade,

check$($Step $>=1),$

check$($char$\_$length$($StepDescription$)>=10)$

$)$;

Create table RECIPE$\_$SAVED$($

UserID int not null,

RecipeID int not null,

Primary Key$($UserID$,$ RecipeID$),$

Foreign Key $($RecipeID$)$ references RECIPE$($RecipeID$)$ on delete cascade,

Foreign Key $($UserID$)$ references USERS$($UserID$)$ on delete cascade

$)$;

Create table USER$\_$FOLLOW$($

UserID int not null,

FollowID int not null,

Primary Key$($UserID$,$ FollowID$),$

Foreign Key$($UserID$)$ references USERS$($UserID$)$ on delete cascade,

Foreign Key$($FollowID$)$ references USERS$($UserID$)$ on delete cascade

$)$;

Create table INGREDIENTS$($

RecipeID int not null,

IngredientName varchar$(255)$ not null,

Price decimal$(10,2)$ not null default $0\mathrm{.}00$ check$($Price $>=0\mathrm{.}00),$

Primary Key$($RecipeID$,$ IngredientName$),$

Foreign Key $($RecipeID$)$ references RECIPE$($RecipeID$)$ on delete cascade

$)$;

Create table USER$\_$RATING$($

UserID int not null,

RecipeID int not null,

Rating int default $0$ check$($Rating $>=0),$

Primary Key$($UserID$,$ RecipeID$),$

Foreign Key$($UserID$)$ REFERENCES USERS$($UserID $)$ on delete cascade,

Foreign Key$($RecipeID$)$ REFERENCES RECIPE$($RecipeID$)$ on delete cascade

$)$;