-- 1. Create tbl_Customer Table (MSSQL & MySQL)
CREATE TABLE tbl_Customer (
    cust_id INT identity(1,1) PRIMARY KEY not null,
    cust_name VARCHAR(150),
    cust_registered_date DATE,
    cust_credit_limit DECIMAL(12,2)
);

-- 1e. Insert Sample Data
INSERT INTO tbl_Customer (cust_name, cust_registered_date, cust_credit_limit) VALUES
('Stephen', '2015-02-23', 800.75),
('Lebron', '2023-05-09', 650.80),
('Giannis', '2019-02-15', 1020.75),
('Nikola', '2022-04-05', 430.75),
('Kevin', '2023-03-15', 1500.00);

select * from tbl_Customer;

SELECT cust_credit_limit, 
    CASE 
        WHEN cust_credit_limit < 500 THEN 'Low'
        WHEN cust_credit_limit >= 500 AND cust_credit_limit < 1000 THEN 'Mid'
        ELSE 'Neutral' 
    end as category
FROM tbl_Customer;
by