It doen't show output, fix the code -- Create the Clients table CREATE TABLE Clients ( ClientID VARCHAR2(10) PRIMARY KEY, ClientName VARCHAR2(255), ZipCode VARCHAR2(10), ClientCode VARCHAR2(1), Contact VARCHAR2(255), OrderDate DATE ); -- Commit the changes to save the table structure COMMIT; -- Populate the Clients table with data from Figure 2 INSERT INTO Clients (ClientID, ClientName, ZipCode, ClientCode, Contact, OrderDate) VALUES ('B5182', 'Basic Broadcasting', '60631', 'A', 'Sammy', TO_DATE('08/03/2019', 'MM/DD/YYYY')), ('C1825', 'Computer Capers', '60656', 'A', 'Sammy', TO_DATE('01/18/2020', 'MM/DD/YYYY')), ('D8125', 'David D. Davies', '60625', 'B', 'George', TO_DATE('02/02/2020', 'MM/DD/YYYY')), ('E5051', 'Edward\'s Enterprise', '60604', 'A', 'Paula', TO_DATE('02/28/2020', 'MM/DD/YYYY')), ('F5150', 'Frank\'s Fixtures', '60629', 'C', 'Paula', TO_DATE('01/07/2019', 'MM/DD/YYYY')), ('J4712', 'Jerry\'s Journals', '60634', 'F', 'Pete', TO_DATE('01/22/2020', 'MM/DD/YYYY')), ('M1758', 'Montrose Muffler', '60630', 'A', 'Sammy', TO_DATE('12/13/2019', 'MM/DD/YYYY')), ('M4158', 'Music for the Many', '60656', 'C', 'Paula', TO_DATE('12/02/2019', 'MM/DD/YYYY')), ('S8158', 'Styles on State', '60608', 'A', 'Steve', TO_DATE('02/12/2020', 'MM/DD/YYYY')), ('T0818', 'Taxes and More', '60618', 'B', 'Janet', TO_DATE('12/20/2021', 'MM/DD/YYYY')); -- Commit the changes to save the table structure COMMIT; SELECT ClientID, ClientName FROM Clients WHERE ClientName LIKE '%mu%';

It doen't show output, fix the code

-- Create the Clients table

CREATE TABLE Clients (

ClientID VARCHAR2(10) PRIMARY KEY,

ClientName VARCHAR2(255),

ZipCode VARCHAR2(10),

ClientCode VARCHAR2(1),

Contact VARCHAR2(255),

OrderDate DATE

);
-- Commit the changes to save the table structure
COMMIT;

-- Populate the Clients table with data from Figure 2

INSERT INTO Clients (ClientID, ClientName, ZipCode, ClientCode, Contact, OrderDate)

VALUES

('B5182', 'Basic Broadcasting', '60631', 'A', 'Sammy', TO_DATE('08/03/2019', 'MM/DD/YYYY')),

('C1825', 'Computer Capers', '60656', 'A', 'Sammy', TO_DATE('01/18/2020', 'MM/DD/YYYY')),

('D8125', 'David D. Davies', '60625', 'B', 'George', TO_DATE('02/02/2020', 'MM/DD/YYYY')),

('E5051', 'Edward\'s Enterprise', '60604', 'A', 'Paula', TO_DATE('02/28/2020', 'MM/DD/YYYY')),

('F5150', 'Frank\'s Fixtures', '60629', 'C', 'Paula', TO_DATE('01/07/2019', 'MM/DD/YYYY')),

('J4712', 'Jerry\'s Journals', '60634', 'F', 'Pete', TO_DATE('01/22/2020', 'MM/DD/YYYY')),

('M1758', 'Montrose Muffler', '60630', 'A', 'Sammy', TO_DATE('12/13/2019', 'MM/DD/YYYY')),

('M4158', 'Music for the Many', '60656', 'C', 'Paula', TO_DATE('12/02/2019', 'MM/DD/YYYY')),

('S8158', 'Styles on State', '60608', 'A', 'Steve', TO_DATE('02/12/2020', 'MM/DD/YYYY')),

('T0818', 'Taxes and More', '60618', 'B', 'Janet', TO_DATE('12/20/2021', 'MM/DD/YYYY'));

-- Commit the changes to save the table structure
COMMIT;

SELECT ClientID, ClientName
FROM Clients
WHERE ClientName LIKE '%mu%';