-- Fictional demonstration only. SQL Server SELECT; creates or changes no tables.
WITH IncomingFiles AS (
 SELECT * FROM (VALUES
 ('Operations', 'Fuel export', 124, 'Ready'),
 ('Finance', 'Monthly sales', 286, 'Ready'),
 ('Operations', 'Mileage log', 87, 'Review'),
 ('Finance', 'Vendor list', 62, 'Ready')
 ) AS v(Team, FileName, RecordCount, ReviewStatus)
)
SELECT Team, COUNT(*) AS FileCount, SUM(RecordCount) AS TotalRecords,
 SUM(CASE WHEN ReviewStatus = 'Review' THEN 1 ELSE 0 END) AS FilesToReview
FROM IncomingFiles
GROUP BY Team
ORDER BY Team;