Untitled

CREATE TABLE customer (

    cust_no Numeric(4),
    Lname VARCHAR(10),
    Fname VARCHAR(15),
    Address VARCHAR(20),
    city VARCHAR(50),
    states VARCHAR(10),
    pin VARCHAR(6),
    birth_date DATE
);


INSERT INTO customer VALUES
    (1, 'samir', 'shrestha', '123 Main St', 'New York', 'NY', '10001', '1990-05-15'),
    (2, 'manjil', 'sharma', '456 Elm St', 'Los Angeles', 'CA', '90001', '1985-09-20'),
    (3, 'sumit', 'thokar', '789 Oak St', 'Chicago', 'IL', '60601', '1978-12-10'),
    (4, 'nischal', 'pandit', '101 Pine St', 'Houston', 'TX', '77001', '1995-03-25'),
    (5, 'kritim', 'bista', '202 Cedar St', 'Miami', 'FL', '33101', '1980-07-30')


SELECT * FROM customer