SQL Basics · SELECT * · FROM
1. Your first query
Concept: SELECT * · FROMshow
A SQL query is a question you ask the database. FROM names the table to look in, and SELECT says which columns you want back. The star * is shorthand for every column, so SELECT * FROM some_table returns the whole table: every column, every row.
Example (different data):
SELECT * FROM pets;
Your task
It's your first day as a data analyst, and before answering any questions you want to see what the users table actually holds.
Return every column and every row of the users table.
Solution unlocks after 3 more tries
Starting Postgres in your browser…
query.sql
Output
Write a query and press Run Query (Ctrl/⌘ + Enter).