Ravindra BagaleCourses & study guides Track your progress

2. Install SQLite and DB Browser (Windows and Mac)

2.4 How to Open a Practice Database and Run Your First SELECT

By Last updated:

Why. Seeing your first result table builds confidence fast.

What. Execute SQL runs your statement and shows a results grid.

How. Open raja_coffee.db → Execute SQL → type SELECT → click Run.

Steps

  1. File → Open Database → raja_coffee.db.
  2. Click the Execute SQL tab.
  3. Paste the example query.
  4. Click the Run / play button.
  5. Read the result grid — city and amount.

Examples

Example 1 · dataset: raja_coffee

SELECT order_id, city, amount_inr
FROM orders
ORDER BY order_id
LIMIT 5;

Output

order_idcityamount_inr
1001Pune840.0
1002Mumbai720.0
1003Goa890.0
1004Pune1050.0
1005Kolhapur620.0

Meaning. Your first five coffee orders — read-only.

Ravindra Bagale's Tip

End statements with a semicolon ; — habit that helps on every engine.