Easy SQL

                                                 SQL Assignment – Module 5  SQL Assignment – Module 5 Questions : 1. Display the names of the highest paid programmers for each Language.  2. Display the details of those who are drawing the same salary.  3. Who are the programmers who joined on the same day?  4. Who are the programmers who have the same Prof2?  5. How many packages were developed by the person who developed the cheapest package, where did he/she study? Answer  : ---ARNAB BOSE--- SELECT * FROM PROGRAMMER SELECT * FROM SOFTWARE SELECT * FROM STUDIES ---Q1--- WITH LanguageHighestPaid AS (     SELECT DISTINCT         PROF1 AS LANGUAGE,         FIRST_VALUE(PNAME) OVER(PARTITION BY PROF1 ORDER BY SALARY DESC) AS HIGHEST_PAID_PROGRAMMER     FROM PR...

                                                 SQL Assignment – NEW   SQL Assignment – NEW Questions : 1 Display the “FIRST_NAME” from Employee table using the alias name as Employee_name.  2 Display “LAST_NAME” from Employee table in upper case.  3 Display unique values of DEPARTMENT from EMPLOYEE table.  4 Display the first three characters of LAST_NAME from EMPLOYEE table.  5 Display the unique values of DEPARTMENT from EMPLOYEE table and prints its length.  6 Display the FIRST_NAME and LAST_NAME from EMPLOYEE table into a single column AS FULL_NAME. a space char should separate them.  7 DISPLAY all EMPLOYEE details from the employee table order by FIRST_NAME Ascending.  8. Display all EMPLOYEE details order by FIRST_NAME Ascending and DEPARTMENT Descending.  9 Display details for EMPLOYEE...

                          SQL Assignment – Module 4  SQL Assignment – Module 4 Questions : 1. What is the cost of the costliest software development in Basic?  2. Display details of Packages whose sales crossed the 2000 Mark.  3. Who are the Programmers who celebrate their Birthdays during the Current Month?  4. Display the Cost of Package Developed By each Programmer.  5. Display the sales values of the Packages Developed by each Programmer.  6. Display the Number of Packages sold by Each Programmer.  7. Display each programmer’s name, costliest and cheapest Packages Developed by him or her.  8. Display each institute name with the number of Courses, Average Cost per Course.  9. Display each institute Name with Number of Students.  10. List the programmers (form the software table) and the institutes they studied.  11. How many packages were developed by students, who...