Posts

Showing posts with the label Institutes

SQL ASSIGNMENT

 SQL  ASSIGNMENT-3 1. How many Programmers Don’t know PASCAL and C.  2. Display the details of those who don’t know Clipper, COBOL, or PASCAL.  3. Display each language name with AVG Development Cost, AVG Selling Cost, and AVG Price per Copy.  4. List the programmer names (from the programmer table) and No. Of Packages, each has developed.  5. List each PROFIT with the number of Programmers having that PROF and the number of packages in that PROF.  6. How many packages are developed by the most experienced programmer from BDPS.  7. How many packages were developed by the female programmers earning more than the highest-paid male programmer?  8. How much does the person who developed the highest selling package earn and what course did HE/SHE undergo.  9. In which institute did the person who developed the costliest package study?  10. Display the names of the programmers who have not developed any packages.  11. Display th...