SALARY oduction 45000 HR 70000 anagemer 120000 67000 145000 EMPNO EMP_NAME DEPT E101 Amit E102 Amit E103 sunita E105 sunita IT E106 mahesh Civil DOJ 12-Mar-00 03-Jul-02 11-Jan-01 mysore 01-Aug-01 mysore 20-Sep-03 Mumbai BRANCH Bangalore Bangalore Perform the following 1. Display all the fields of employee table 2. Retrieve employee number and their salary 3. Retrieve average salary of all employee 4. Retrieve number of employee 5. Retrieve distinct number of employee 5. Retrieve total salary of employee group by employee name and count similar names 7. Retrieve total salary of employee which is greater than >120000 3. Display name of employee in descending order 9. Display details of employee whose name is AMIT and salary greater than 50000;
SALARY oduction 45000 HR 70000 anagemer 120000 67000 145000 EMPNO EMP_NAME DEPT E101 Amit E102 Amit E103 sunita E105 sunita IT E106 mahesh Civil DOJ 12-Mar-00 03-Jul-02 11-Jan-01 mysore 01-Aug-01 mysore 20-Sep-03 Mumbai BRANCH Bangalore Bangalore Perform the following 1. Display all the fields of employee table 2. Retrieve employee number and their salary 3. Retrieve average salary of all employee 4. Retrieve number of employee 5. Retrieve distinct number of employee 5. Retrieve total salary of employee group by employee name and count similar names 7. Retrieve total salary of employee which is greater than >120000 3. Display name of employee in descending order 9. Display details of employee whose name is AMIT and salary greater than 50000;
Chapter7: Developing An Excel Application
Section: Chapter Questions
Problem 3RA
Related questions
Question
Need emergency answer. Don't reject.
First fill the above image table and answer the following questions with SQL code
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Step 1: 1. Display all the fields of employee table
VIEWStep 2: 2. Retrieve employee number and their salary
VIEWStep 3: 3. Retrieve average salary of all employees
VIEWStep 4: 4. Retrieve number of employees
VIEWStep 5: 5. Retrieve distinct number of employees
VIEWStep 6: 6. Retrieve total salary of employees group by employee name and count similar names
VIEWStep 7: 7. Retrieve total salary of employees which is greater than >120000
VIEWStep 8: 8. Display name of employee in descending order
VIEWStep 9: 9. Display details of employee whose name is AMIT and salary greater than 50000
VIEWSolution
VIEWTrending now
This is a popular solution!
Step by step
Solved in 10 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning