CREATE TABLE Salesman (
    s_id INT PRIMARY KEY,
    name VARCHAR(50),
    city VARCHAR(50),
    commission DECIMAL(10, 2)
  
);
CREATE TABLE Customer (
    c_id INT PRIMARY KEY,
    c_name VARCHAR(50),
    city VARCHAR(50),
    grade INT,
    s_id INT,
    FOREIGN KEY (s_id) REFERENCES Salesman(s_id)
);
CREATE TABLE Order_1 (
    o_no INT PRIMARY KEY,
    purchase_amount DECIMAL(10, 2),
    order_date DATE,
    c_id INT,
    s_id INT,
    FOREIGN KEY (c_id) REFERENCES Customer(c_id),
    FOREIGN KEY (s_id) REFERENCES Salesman(s_id)
);

INSERT INTO salesman VALUES  (1, 'nahid', 'barisal', 0.22,1000); 
INSERT INTO salesman VALUES (2, 'ahid', 'risal', 0.23); 
INSERT INTO salesman VALUES (3, 'hid', 'isal', 0.24);
INSERT INTO salesman VALUES (4, 'id', 'sal', 0.25);
1)SELECT name, city
FROM Salesman
WHERE city = 'barisal';
2)