Home/
Kartik Kumar Sheth/Questions
mcqoptions.com Latest Questions
Kartik Kumar Sheth
Asked: 2 years agoIn: General Awareness
In a database BANK, there are two tables with a sample data given below :
Table : EMPLOYEE
ENo. | Name | Salary | Zone | Age | Grade | Dept |
1 | Mona | 70000 | East | 40 | A | 10 |
2 | Muktar | 71000 | West | 45 | B | 20 |
3 | Nalini | 60000 | East | 26 | A | 10 |
4 | Sanaj | 65000 | South | 36 | A | 20 |
5 | Surya | 58000 | North | 30 | B | 30 |
Table: DEPARTMENT
Department | DName | HOD |
10 | Computer | 1 |
20 | Economics | 2 |
30 | English | 5 |
Write SQL queries for the following :
(i) To display ENO, ENAME, SALARY and corresponding DNAME of all the employees whose age is between 25 and 35 (both inclusive)
(ii) To display DNAME and corresponding ENAME from both tables. Hint: HOD of the DEpARTMENT table should be matched with ENO of the Employee table for getting desired result.
(iii) To display ENAME, SALARY ZONE and INCOME TAX (30% of salary) of all the employees with appropriate column headings.