SQLCOMMANDS.sql

CREATE DATABASE COLLEGES;
USE COLLEGES;
CREATE TABLE SAVEETHA(
NUM INT PRIMARY KEY NOT NULL,
DEPTLIST VARCHAR(216) NOT NULL,
TOTAL INT NOT NULL,
INCOME INT NOT NULL,
FACULTIES INT NOT NULL
);

CREATE TABLE SSE(
NUM INT PRIMARY KEY NOT NULL,
DEPTLIST INT NOT NULL ,
FACULTIES_NAME VARCHAR(216),
SALARY INT NOT NULL,
FOREIGN KEY(NUM) REFERENCES SAVEETHA(NUM)
);

INSERT INTO SAVEETHA VALUES (1,'A',300,50,10);
INSERT INTO SAVEETHA VALUES (2,'B',200,500,5);
INSERT INTO SAVEETHA VALUES (3,'C',100,502,7);
INSERT INTO SAVEETHA VALUES (4,'D',50,200,6);


INSERT INTO SSE VALUES (1, 5, 'KONDA', 100);
INSERT INTO SSE VALUES (2, 4, 'REDDY', 200);
INSERT INTO SSE VALUES (3, 4, 'NANA', 10);
INSERT INTO SSE VALUES (4, 4, 'MENTOR', 22);
SELECT * FROM SSE;
INSERT INTO SSE VALUES(3,2,'KONDA',202);
SELECT * FROM SSE;
SELECT*FROM SAVEETHA;
SELECT*FROM SAVEETHA LIMIT 1;
SELECT DEPTLIST AS SIMATS FROM SAVEETHA;
SELECT SALARY FROM SSE;
SELECT * FROM SSE LIMIT 2;

SELECT *FROM SSE;
SELECT *FROM SAVEETHA;  

SELECT * FROM SSE 
WHERE FACULTIES_NAME LIKE '%ME%';

UPDATE SSE
SET DEPTLIST=3
WHERE NUM=3;

SELECT *FROM SSE;

SELECT *FROM SSE
WHERE NUM BETWEEN 1 AND 3;


DELETE FROM SSE WHERE NUM=4;
SELECT *FROM SSE;


SELECT *FROM SAVEETHA
JOIN SSE ON SAVEETHA.NUM=SSE.NUM;