Your first 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';
