Simple Queries in SQL || Sumita Arora || Class 12 || Computer science || Information practices || Solution

Simple Queries in SQL sumita arora solution || Simple Queries in SQL class 12 sumita arora solution || Simple Queries in SQL class 12 sumita arora || Simple Queries in SQL sumita arora || sumita arora Simple Queries in SQL || sumita arora Simple Queries in SQL solution || Simple Queries in SQL sumita arora practical solution || sumita arora practical solution || Simple Queries in SQL class 12 solution || Simple Queries in SQL class 12

Q1 = Write a query to display EName and Sal of employees whose salary is greater than or equal to 2200 from table Empl.

Q2= write a query to display details of employees who are not getting commission from table Empl.

Q3= 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.

Q4 = Write a query to display the name, job title and salary of employee who do not have manager.

Q5= Write a query to display the name of employee whose name contains 'A' as third alphabet.

Q6 = Write a query to display the name of employee whose name contains T as the last alphabet.

Q7=  Write a query to display the name of employee whose name contains 'M' as first alphabet 'L' as third alphabet.

Q8 = Write a query on the customers table whose output will exclude all customers with a rating <= 100, unless they are located in Shimla.

Q9 =  Write a query that selects all orders (Order table) except those with zeros or NULLS in the amt field.

Q 10 =Write SQL commands for the following on the basis of given table STUDENT:

1=  Display the names of the students who are getting a grade 'C' in either GAME or SUPW.

2 =Display the different games offered in the school.

3 = Display the SUPW taken up by the students, whose name starts with 'A'.

Q 11 = Write SQL commands for the following on the basis of given table SPORTS:

1 = Display the names of the students who have grade 'C’ in either Game1 or Game2 or both.

2 = Display the names of the students who have same game for both Game1 and Game2.

3 = Display the games taken up by the students, whose name starts with 'A'.

Q12= Write SQL commands for the following on the basis of given table CLUB :

(a) To show all information about the swimming coaches in the club.

(b) To list names of all coaches with their date of appointment (DATOFAPP) in descending order.

(c) To display a report, showing coachname, pay, age and bonus (15% of pay) for all the coaches.

Q13.

Table: CLUB

Give the output of following SQL statements:

(i) SELECT COUNT (DISTINCT SPORTS) FROM Club;
(ii) SELECT MIN(Age) FROM CLUB WHERE Sex = 'F';
(iii) SELECT AVG(Pay) FROM CLUB WHERE Sports = 'KARATE' ;
(iv) SELECT SUM(Pay) FROM CLUB WHERE Datofapp > '31/01/98'

Q14=  Write SQL commands for the following on the basis of given table STUDENT1 :

(a) Select all the Nonmedical stream students from STUDENT1.

(b) List the names of those students who are in class 12 sorted by Stipend.

(c) List all students sorted by AvgMark in descending order.

(d) Display a report, listing Name, Stipend, Stream and amount of stipend received in a year assuming that the Stipend is paid every month.

Q15. Give the following table:-

Table: STUDENT

Give the output of following SQL statements :

(i) SELECT MIN(AvgMark) FROM STUDENT WHERE AvgMark < 75 ;
(ii) SELECT SUM(Stipend) FROM Student WHERE Grade = 'B' ;
(iii) SELECT AVG(Stipend) FROM Student WHERE Class = '12A' ;
(iv) SELECT COUNT(DISTINCT) FROM Student ;

Q16 = Write SQL commands for the following on the basis of given table :

(a) Select all the PROG type published by BPB from Library.

(b) Display a list of all books with Price more then 130 and sorted by Qty.

(c) Display all the books sorted by Price in ascending order.

Q17. Write SQL commands for the following on the basis of given table MOV :

(a) Display a list of all movies with Price over 20 and sorted by Price.

(b) Display all the movies sorted by QTY in decreasing order.

(c) Display a report listing a movie number, current value and replacement value for each movie in the above table. Calculate the replacement value for all movies as QTY * Price * 1.15 .

Q18 = Write SQL commands for the following on the basis of given table GRADUATE :

(a) List the names of those students who have obtained Rank 1 sorted by NAME.

(b) Display a report, listing NAME, STIPEND, SUBJECT and amount of stipend received in a year assuming that the STIPEND is paid every month.

Q19=  Write SQL commands for the following on the basis of given table relation Teacher:

(a) To show all information about the teacher of history department .

(b) To list the names of female teachers who are in Hindi department .

(c) To list names of all teachers with their date of joining in ascending order.

   

 

Q20= Given the following table :Give the output of following SQL statement :

(i) =SELECT TRUNCATE(AvgMark) FROM Student1 WHERE AvgMark < 75;

(ii) =SELECT ROUND(AvgMark) FROM Student1 WHERE Grade = 'B';

(iii)= SELECT CONCAT(Name, Stream) FROM Student1 WHERE Class = '12A';

(iv) = SELECT RIGHT(Stream, 2) FROM Student1;