Scribd
Upload
23 views1 page

MySQL Operators Questions

The document contains a list of MySQL operator questions aimed at querying employee salary and department information. It includes tasks such as calculating salary increases, bonuses, and filtering employees based on specific criteria. The questions cover various SQL operations like selection, filtering, and calculations related to employee data.

Uploaded by

kousar banu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
23 views1 page

MySQL Operators Questions

The document contains a list of MySQL operator questions aimed at querying employee salary and department information. It includes tasks such as calculating salary increases, bonuses, and filtering employees based on specific criteria. The questions cover various SQL operations like selection, filtering, and calculations related to employee data.

Uploaded by

kousar banu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

MySQL operators questions

1. Display the name of each employee along with their original salary and
the salary after applying a 20% increase.

2. Display the salary of all employees with a 500 bonus.

3. Calculate the annual salary for each employee, assuming their monthly
salary is multiplied by 12, and an additional bonus of 1500 is added.

4. List employees whose salary is not equal to 1600.

5. Find employees earning less than or equal to 1250.

6. Find employees who work in department 30 and have a job as


'SALESMAN'.

7. List employees in department 10 or department 20.

8. Find employees who are not managers.

9. Find employees whose salary is greater than 2000 and whose job is
'ANALYST'.

10. Find employees who work in department 30 or have a salary greater


than 1500.

You might also like