SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Customer ( Cust_ID INT PRIMARY KEY, Cust_name VARCHAR(255), Cust_Add VARCHAR(255), Cust_Ph# VARCHAR(255) ); CREATE TABLE Operator ( OP_ID INT PRIMARY KEY, OP_name VARCHAR(255), OP_ph# VARCHAR(255), OP_Emaiadd VARCHAR(255) ); CREATE TABLE Complaint ( Comp_ID VARCHAR(255) PRIMARY KEY, Comp_date DATE, Comp_type VARCHAR(255), Comp_Status VARCHAR(255), Cust_ID INT NOT NULL, OP_ID INT NOT NULL, FOREIGN KEY (Cust_ID) REFERENCES Customer(Cust_ID) , FOREIGN KEY (OP_ID) REFERENCES Operator(OP_ID) ); INSERT INTO Customer (Cust_ID, Cust_name, Cust_Add, Cust_Ph#) VALUES (1, 'Rahul', 'CANADA,London', +1321328190), (2, 'Jane Smith', '456 Park Ave', 5552345678), (3, 'Bob Johnson', '789 Elm St', 5553456789); INSERT INTO Operator (OP_ID, OP_name, OP_ph#, OP_Emaiadd) VALUES (1, 'Alice', 5558765432, 'alice@example.com'), (2, 'Bob', 5559876543, 'bob@example.com'), (3, 'Charlie', 5551234567, 'charlie@example.com'); INSERT INTO Complaint (Comp_ID, Comp_Type, Comp_Date, Comp_Status, Cust_ID, OP_ID) VALUES ('CMPT101', 'CB', '2022-12-29', 'Resolved', 1, 1), ('CMPT102', 'CSB', '2022-12-29', 'Pending', 2, 2), ('CMPT103', 'CSB', '2023-01-10', 'Pending', 3, 3); SELECT * FROM Complaint WHERE Comp_Type LIKE 'CSB%'; SELECT Comp_ID, Comp_Status FROM Complaint WHERE Comp_date >= '2022-12-01' AND Comp_date <= '2023-01-15'; SELECT * FROM Complaint ORDER BY Comp_Status ASC;