day3SQLQuery3.sql

use JANUARY2026
   ---1. TABLE CREATION : Employee Table
CREATE TABLE Employeee
(
    Eid INT,
    Ename VARCHAR(25),
    Eage INT,
    Department VARCHAR(25),
    Esalary MONEY
);


   2. INSERTING DATA 
INSERT INTO Employeee VALUES
(1,'Suresh',20,'Full Stack',21000),
(2,'Mahesh',21,'Full Stack',21000),
(3,'Ramesh',22,'Cloud',25000),
(4,'Jayesh',22,'QA',23000),
(5,'Naresh',24,'QA',24000);

---3. CALCULATED COLUMN : Salary Bonus (+5000)
SELECT 
    Eid,
    Ename,
    Esalary,
    (Esalary + 5000) AS Salary_Bonus
FROM Employeee;

---4. CALCULATED COLUMN : Salary Increment (5%)
SELECT 
    Eid,
    Ename,
    Esalary,
    (Esalary * 1.05) AS Increment
FROM Employeee;

---5. LOGICAL OPERATORS : IN
SELECT * FROM Employeee
WHERE Eid IN (1,2);

SELECT * FROM Employeee
WHERE Department IN ('Cloud','QA');

---6. LOGICAL OPERATORS : AND
SELECT * FROM Employeee
WHERE Department = 'QA' AND Esalary = 24000;

---7. LOGICAL OPERATORS : OR
SELECT * FROM Employeee
WHERE Department = 'QA' OR Esalary = 24000;

SELECT * FROM Employeee
WHERE Department = 'QA' 
   OR Esalary = 24000 
   OR Department = 'Full Stack';

---8. COMBINED AND / OR CONDITIONS
SELECT * FROM Employeee
WHERE Department = 'QA'
AND (Esalary = 24000 OR Eage = 22);

---9. COMPARISON OPERATORS
SELECT * FROM Employeee
WHERE Department = 'Full Stack'
AND Esalary > 50000;

SELECT * FROM Employeee
WHERE Esalary != 21000;

SELECT * FROM Employee
WHERE Department <> 'QA';

---10. INSERT PARTIAL DATA (NULL VALUES)
INSERT INTO Employeee (Eid, Ename, Eage)
VALUES (6,'Kamlesh',25);

---11. CHECKING NULL / NOT NULL
SELECT * FROM Employeee WHERE Esalary IS NULL;
SELECT * FROM Employeee WHERE Esalary IS NOT NULL;

---12. RANGE CONDITIONS : BETWEEN
SELECT * FROM Employeee
WHERE Esalary BETWEEN 21000 AND 25000;

SELECT * FROM Employeee
WHERE Esalary > 21000 AND Esalary < 25000;

---13. UPDATE STATEMENT : Increment Salary by 5%
UPDATE Employeee
SET Esalary = Esalary * 1.05;

SELECT * FROM Employeee;

---14. PATTERN MATCHING : LIKE OPERATOR
-- Names starting with 'S'
SELECT * FROM Employeee
WHERE Ename LIKE 'S%';

-- Names ending with 'h'
SELECT * FROM Employeee
WHERE Ename LIKE '%h';

-- Names ending with 'sh'
SELECT * FROM Employeee
WHERE Ename LIKE '%sh%';


---15. PLACEHOLDER EXAMPLES (Email / Phone)
-- Example: Email ends with gmail.com
-- WHERE Email LIKE '%@gmail.com'

-- Example: Indian phone number
-- WHERE Phone LIKE '+91%'