Class 11 IP Chapter 14 Back Exercise Solutions Sumita Arora New Syllabus

/ Listing11IPSA, Uncategorized / By
1. Write a query to display EName and Sal of employees whose salary is greater than or equal to 2200 from table Empl.
SELECT ename, ...
click here for answers
2. Write a query to display details of employees who are not getting commission from table Empl.
SELECT * ...
click here for answers
3. Write a query to display employee name and salary of those employee who don’t have there salary in the range of 2500 to 4000.
...
click here for answers
4. Write a query to display the name, job title and salary of employee who do not have manager.
SELECT ename, ...
click here for answers
5. Write a query to display the name of employee whose name contains ‘A’ as third alphabet.
...
click here for answers
6. Write a query to display the name of employee whose name contains ‘T as the last alphabet.
...
click here for answers
7. Write a query to display the name of employee whose name contains ‘M’ as first alphabet ‘L’ as third alphabet.
...
click here for answers
8. Write a query on the customers table whose output will exclude all customers with a rating <= 100, unless they are located in Shimla.
...
click here for answers
9. Write a query that selects all orders (Order table) except those with zeros or NULLs in the amt field.
...
click here for answers
10. Write SQL commands for the following on the basis of given table STUDENT :
...
click here for answers
11. Write SQL commands for the following on the basis of given table SPORTS :
...
click here for answers
12. Write SQL commands for the following on the basis of given table CLUB :
...
click here for answers
13. Write SQL commands for the following on the basis of given table STUDENT :
...
click here for answers
14. Write SQL commands for the following on the basis of given table :
...
click here for answers
15. Write SQL commands for the following on the basis of given table MOV :
...
click here for answers
16. Write SQL commands for the following on the basis of given table GRADUATE :
...
click here for answers
17. Write SQL commands for the following on the basis of given table relation Teacher :
...
click here for answers
18. Given the following table :
...
click here for answers