3.6 Practice: First Queries on raja_coffee Orders

By Ravindra Bagale Last updated: 31 October 2026

Why. Practice locks the SELECT pattern into muscle memory.

What. Combine column picks, aliases and LIMIT on raja_coffee orders.

How. Write three short SELECTs yourself, then match the examples.

Steps

Example 1 · dataset: raja_coffee

SELECT order_id, city, amount_inr AS sales_inr
FROM orders
LIMIT 5;

Output

Meaning. Practice set A: orders preview.

Example 2 · dataset: raja_coffee

SELECT product_name, unit_price_inr
FROM products
ORDER BY product_id;

Output

Meaning. Practice set B: full product price list.

Ravindra Bagale's Tip

Save your three queries in a notes file — rebuild them tomorrow without peeking.