SQLize | PHPize | SQLtest

CREATE TABLE ShipmentRecords ( ShipmentID VARCHAR(10) PRIMARY KEY, ImporterName VARCHAR(100), OriginCountry VARCHAR(50), DateArrived DATE, Value DECIMAL(10, 2), Status VARCHAR(30) ); INSERT INTO ShipmentRecords (ShipmentID, ImporterName, OriginCountry, DateArrived, Value, Status) VALUES ('S001', 'Global Imports', 'China', '2025-04-02', 25000.00, 'Pending'), ('S002', 'Ocean Trade Co.', 'Japan', '2025-04-05', 15000.00, 'Cleared'), ('S003', 'Manila Exports', 'USA', '2025-04-10', 20000.00, 'Pending'), ('S004', 'TradeLink Corp', 'South Korea', '2025-04-12', 30000.00, 'Held for Review'), ('S005', 'EastPoint Ltd.', 'Vietnam', '2025-04-15', 18000.00, 'Cleared'); SELECT OriginCountry COUNT(*) AS ShipmentCount, SUM(Value) AS TotalValue FROM ShipmentRecords GROUP BY OriginCountry;