تحديث بديل عبر CSV
شغّل الاستعلام في SQL Editor، وصدّر النتيجة بصيغة CSV، ثم حمّل الملف من أعلى اللوحة.
WITH customer_order_totals AS (
SELECT project_id, SUM(amount) AS order_value
FROM budget_control.customer_orders
GROUP BY project_id
)
SELECT
d.name AS department,
p.code AS project_code,
p.name AS project_name,
COALESCE(o.order_value, 0) AS customer_order_value,
pp.approved_budget,
pp.actual_to_date,
pp.open_commitments,
pp.remaining_uncommitted,
pp.estimate_at_completion,
pp.forecast_overrun,
COALESCE(o.order_value, 0) - pp.estimate_at_completion
AS order_value_less_forecast_cost
FROM budget_control.projects AS p
JOIN budget_control.departments AS d ON d.id = p.department_id
JOIN budget_control.project_performance AS pp ON pp.project_id = p.id
LEFT JOIN customer_order_totals AS o ON o.project_id = p.id
ORDER BY d.name, p.code;