CBSE COMPUTER SCIENCE

DOWNLOAD : PYTHON, MYSQL, MYSQL-CONNECTOR PACKAGE IN A SINGLE PLACE - https://drive.google.com/drive/folders/1VvsQQB_L079eNF9UTDQ1TvDetvJUUBMG?usp=sharing

Download MySql connector package for interface python with mysql

Ref : www.computertutor.in for study notes, project,practical etc.,

22. Write SQL queries for (a) to (f) and write the outputs for the SQL queries mentioned shown in (i) to (iv) parts on the basis of tables ITEMS and TRADERS.

do it yourself and send the ans...

19. Answer the questions (a) and (b) on the basis of the following tables STORE and ITEM.

(a) Write SQL statements for the following: (i) To display TEACHERNAME, PERIODS of all teachers whose periods are more than 25. (ii) To display all the information from the table SCHOOL in descending order of experience. (iii) To display DESIGNATION without duplicate entries from the table ADMIN. (iv) To display TEACHERNAME, CODE and corresponding DESIGNATION from tables SCHOOL and ADMIN of Male teachers. (b) Give the output of the following SQL queries : (i) SELECT DESIGNATION, COUNT (*) FROM ADMIN GROUP BY DESIGNATION HAVING COUNT (*)<2; (ii) SELECT MAX (EXPERIENCE) FROM SCHOOL; (iii) SELECT TEACHERNAME FROM SCHOOL WHERE EXPERIENCE > 12 ORDER BY TEACHERNAME; (iv) SELECT COUNT (*), GENDER FROM ADMIN GROUP BY GENDER;

18. Consider the following tables SCHOOL and ADMIN and answer (a) and (b) parts of this question