Drill 1 of 12 in SQL Basics
0

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).