Write a SQL query to analyze operational performance by site, including joins across orders, shipments, and costs tables.