Project 2: Blog Posts Query
SQL Architect
Builds on these lessons
Query Task
Objective
A DBMS (Database Management System) is the software actually storing your tables and running your queries — PostgreSQL, MySQL, and SQLite are all examples. The SQL you write is the same core language across all of them.
You're given a posts table with columns id, title, and author.
Task: write a query that returns every column, for every row, in the posts table.
query.sql
SELECT * FROM posts;
* Hint: Correct characters turn green, incorrect ones turn red.
Query Results
🗄️
Execute your query to see results