data-modeling-order-management-data/step5.md at main · DataStax-Academy/data-modeling-order-management-data · GitHub

Order Management Data Modeling ℹ️ For technical support, please contact us via email or LinkedIn.

Design query Q2

✅ Find all information about order 113-3827060-8722206; sort items by name (asc):

Solution

EXPAND ON;

SELECT * 
FROM orders_by_id
WHERE order_id = '113-3827060-8722206';

EXPAND OFF;