-- If experience and Salary is stored as monthly, if they are stored yearly basis then you can add the Logic to get the monthly salary and experience in monthSELECT Name, Experience, SalaryFROM tblEmployeeWHERE Experience > 10 AND Salary > 15000;SELECT * FROM tblEmployeeWHERE Name LIKE '[^aeiouAEIOU]%[aeiouAEIOU]';

If experience and Salary is stored as monthly, if they are stored yearly basis then you can add the Logic to get the monthly salary and experience in month
SELECT 
    Name,
    Experience,
    Salary
FROM tblEmployee
WHERE Experience > 10 AND Salary > 15000;

SELECT 
        * 
FROM tblEmployee
WHERE Name LIKE '[^aeiouAEIOU]%[aeiouAEIOU]';


Comments