So, did you succeed?
Let's now add it together and for this,
I'll add a new value into my reviews table.
And for the columns that I wanna set, I wanna set everything
except for the unique ID and the date.
Because the date will be populated automatically,
if you recall that.
So instead,
now let's see which columns we do have to set here,
and there would, for example, be the reviewer name.
So we definitely wanna set that.
We wanna set the rating.
We don't have to set the text, that's also optional.
I forgot to mention this, but that's also optional
because we did not set, not null,
as a setting for this column.
So we don't have to set the text, but I will set one here.
And then, for the restaurant ID, we also need a value,
so that this rating is linked to some restaurant.
Date and ID are omitted for the reasons mentioned.
Now for the values.
And I'll split this across multiple lines
to make it a bit easier to read.
The reviewer name here, let's say that's me,
Schwarzmuller.
And the contrite's review or the rating,
which I wanna leave here, let's say is a four.
And the text is, "This was awesome."
So quite short text.
We could enter a very long text here,
but I don't wanna waste your time with me typing
a super long essay here.
And now for the restaurant ID,
I do have various restaurants.
Let's quickly select all the restaurants here, in a new tab.
And let's say, I wanna rate the Burger House.
So that would have an ID of two.
That's the ID of that restaurant.
So here, two, is the value which I specify
for restaurant ID.
And now we can execute this,
and this should have been added.
Now let's add another rating by Jules Barnes,
some made up name here.
Let's say it's a two.
And I don't wanna have a text here.
So I'll not set a text.
I'll delete this column from the list here.
And I wanna rate the Burger House as well.
This should also work if I submit this, and it does.
And now I'll re-add the text and leave another rating,
also, let's say by Jules Barnes,
but now I will rate a different restaurant.
I'll rate LAMAMA.
So that has the ID three.
And let's say that is a four here.
And of course I did re-add the text here.
So I submitted this accidentally and it failed.
I need to, of course, add a value for the text field.
"This was delicious," could be the text.
Now let's submit this, and now it worked.
And now let's add one more rating.
Let's say a five,
by,
Anna Schulz,
where I also have a text of, "Amazing."
So, very positive reviews here, as you can see.
And let's say we are rating LAMAMA again.
So we keep the restaurant ID set to three.
So that all, all's have worked.
Now here I'll select all entries from reviews.
And I can see my reviews here.
Now, what you can see,
is that the date was set automatically as promised,
that the ID was set automatically,
and that the text is null for some values,
for one value to be precise,
because it was optional and wasn't enforced to be non null.
So therefore, now we've got these four ratings.
Now, of course, with that,
we now did store a bunch of dummy data
and we can not play around with them.
We can, for example, query it as we learned it.
For example, if I wanna fetch all the reviews
that have a rating greater than three,
we could add a where clause here,
and search for reviews where rating is greater than three.
And if I do that, I don't see all the ratings,
but only those that do have a rating greater than three.
And of course there are various ways
of mixing and matching that,
but we did learn how that works before already.
Nonetheless, feel free to practice it again
and play around with that.
So definitely also do query all that data
that we stored here to, again,
practice working with the where clause
and with the select statement in general.
Maybe revisit the querying lectures
from earlier in this section.
When it comes to me, I wanna show you something new,
and therefore in the next lecture,
I will show you how we can now query data
across multiple tables.
Because that is the brand new feature here,
that we have related data, stored in different tables.