🔍 SQL SORGU
-- ORDER TOTAL
SELECT id, total, state, garson_code, siramatik FROM orders WHERE id = 9;
-- ITEMS TOTAL
SELECT SUM(qty * unit_price) AS calculated_total FROM order_items WHERE order_id = 9;
-- ITEMS DETAIL
SELECT * FROM order_items WHERE order_id = 9 ORDER BY id;