CSE-132 / hw_1 / hw_1.sql
hw_1.sql
Raw
-- CREATE TABLE customer
--     ("name" VARCHAR(100),
--     credit int)

-- CREATE TABLE loan 
--     ("no" VARCHAR(100),
--     "type" VARCHAR(100),
--     minCredit int)

-- CREATE TABLE borrower 
--     (cname VARCHAR(100),
--     lno VARCHAR(100), 
--     due date)


-- INSERT INTO customer 
--     VALUES 
--         ('below_600_v1', 520),
--         ('below_600_v2', 450)

-- INSERT INTO loan 
--     VALUES 


INSERT INTO borrower (cname, lno)
    VALUES 
        ('Joe', 14
),('Bella', 14
),('Omega', 14
),('Tim', 14
),('Auto', 14
)