Write SQL Queries for following Employee table : EMPLOYEE_ID Name EMAIL HIRE_DATE SALARY DEPARTMENT 101 Juniad Juniad@abc.com | 2010-06-18 110000.00 CS 100000.00 Sales 88000.00 |Marketing 102 Irfan Irfan@abc.com 2011-04-16 Hassan Hassan@abc.com 2010-03-08 Fahad@abc.com 2013-01-28 2012-01-28 103 104 Fahad 90000.00 Sales 105 Husnain Hus@abc.com 55000.00 ES 1. Write a query to display sales and marketing department data. 2. Write a query to get the names, salary, PF of all the employees (PF is calculated as 15% of salary). 3. Write a query to get the total salaries payable to employees. 4. Write a query to get the average salary and number of employees in the employees table.

Write SQL Queries for following Employee table : EMPLOYEE_ID Name EMAIL HIRE_DATE SALARY DEPARTMENT 101 Juniad Juniad@abc.com | 2010-06-18 110000.00 CS 100000.00 Sales 88000.00 |Marketing 102 Irfan Irfan@abc.com 2011-04-16 Hassan Hassan@abc.com 2010-03-08 Fahad@abc.com 2013-01-28 2012-01-28 103 104 Fahad 90000.00 Sales 105 Husnain Hus@abc.com 55000.00 ES 1. Write a query to display sales and marketing department data. 2. Write a query to get the names, salary, PF of all the employees (PF is calculated as 15% of salary). 3. Write a query to get the total salaries payable to employees. 4. Write a query to get the average salary and number of employees in the employees table.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Draw a windows navigation diagram from the picture below.
Write a brief comment about IPv6, the Internet, VPNs, and VoIP. Their benefits are included.
Write only the steps on how to embed YouTube video in Weebly.
Please help me with this. I am having trouble understanding what to do Please create an analog clock and a calendar using html, css and JavaScript (Refer to images below) Thank
Have there been any new updates to StuffDOT's site that make it easier to navigate?
What is the most trending programing Interface and language for develpors in world's sofftware houses.?
Based on the Figure 1.1 below, list out the widgets used in the figure. What do you want in your Cofee? Cream Sugar How do you want to pay? Cash Card/Online SUBMIT ORDER Figure 1.1
What's wrong with Android Pie?
1 - Provide a screenshot of a good interface (mobile app, website, software, TV menu interface, etc.)2 - Explain what makes it a good interface (style, functionality, etc.)3 - Provide a screenshot of a bad interface (mobile app, website, software, TV interface, etc.)4 - Explain what makes it a bad interfaced interface
can you make a Website for me, its about a casino restaurant. the name would be called alpha casino. could you add a home, menu, and checkout. make the website like an online fast food. website. add the home , menu, checkout at the top left page, and hyper link it so you can press on them and they will go to the pages. can you also make a button for the home page that say order. like make a big green button. also for the about us section can you make a 3 column layout that has the picture and welcome to alpha casino at the top , the middle has the about us section, abd at the bottom as the contact us. add a fake adress, and fake email. for the menu please add a button. also add 4 menu dishes. you can choose what. for the menu, add the name , what the dish is made of and how much it cost. also use a table html. make sure the buttons work. while calculating the total amount. lastly can you make a checkout section that counts the total amount of food has been clicked. and add the name and…