DBMS

--------Ans.To.The.Q.No-1--------------

--------Step 1--------------

CREATE TABLE info(
    Name CHAR(20),
    Address CHAR(20),
    Salary INT(20),
    Due INT(20)
);




--------Step 2--------------

INSERT INTO info
VALUES ('Rahima','Sylhet',20000,15000), ('Sakib','Dhaka',5000,17000), ('Amin','Sylhet',29000,25000), ('Sohel','Ctg',35000,45000), ('Bulbul','Ctg',17000,5000);



--------Ans.To.The.Q.No-2--------------

SELECT Name FROM info
WHERE Address LIKE 'S%' OR Address LIKE 'D%' OR Address LIKE 'C%';


--------Ans.To.The.Q.No-3--------------

SELECT Salary FROM info
ORDER BY Salary DESC;


--------Ans.To.The.Q.No-4--------------
SELECT Name FROM info
WHERE Due > 20000 AND Address == 'Sylhet';



--------Ans.To.The.Q.No-5--------------

UPDATE info
SET Address = 'Khulna'
WHERE Name = 'Sohel';