Your first table
3. Query the table
CREATE TABLE basics
Entity Relationship Diagrams (ERD)
DROP - how to remove a table

Instruction

Good job! You've added your first row to your first table and the museum exhibition starts to fill up!

Before we proceed, let's check if everything is working all right. We're going to write a simple SQL query.

Exercise

Let's find out if the row has been inserted correctly. Write a simple SQL query which will select the production_year column for the row with the name 'Matryoshka'.

Tip: you may want to check out our SQL Queries course.

Stuck? Here's a hint!

Type

SELECT production_year 
FROM exhibit 
WHERE name = 'Matryoshka';

Console

Code editor

Result

TableConsole