Write each query here, and run it on a real Postgres database in your browser.
Write the queries Simplified's server sends for its videos, and get back exactly the rows it needs.
Scenario
Simplified keeps every video you watch in a table called videos. You write the query its server sends each time it needs one.
Simplified keeps its videos in a Postgres table called videos, one row for each video.
Can you write the queries Simplified's server sends to it?
Each step runs your query on this table, in real Postgres.
Simplified's team wants a list of every video, with how long it runs.
Send back each video's title and seconds.
A learner opens a video called The schema.
Find its row by title, and send back its chapter and seconds.
Send back the title of every video that runs for exactly 95 seconds.
Two rows should come back.
Send back every column of the row whose id is 4.
An assistant wrote this query, to find how long Servers runs.
Run it, read the error, then fix it.
Say Simplified's server looks for a video called Joins, which hasn't been made yet.
Predict what comes back, then send back that video's title and seconds.
unterminated quoted string
A quote is missing.
Text goes between two single quotes, like 'Servers'.
column "Servers" does not exist, after writing "Servers"
Text goes in single quotes, never double quotes.
So write 'Servers', not "Servers".
relation "vidoes" does not exist
Postgres can't find a table with that name.
Check the name after FROM: videos.
syntax error at or near "FROM"
Look just before FROM.
A comma after the last column, like title, seconds, FROM, is one too many.
Not yet: your columns aren't the ones the step needs
Name exactly the columns the step asks for, in its order, between SELECT and FROM.
Each step passes once its query sends back the right rows. Then mark the lab complete to unlock the next lesson.