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

Pro_Lab 7 1. Modify the toolbar of the ContactActivity to display the proximity sensor readings. Add the proximity sensor service so that this works. 2. Modify the app so that when the user long-clicks the cell number of a contact, the text messaging service is opened instead of the phone service. You will have to have a permission in the manifest to send text (SMS) messages. 3. Modify the compass to report NW, NE, SW, and SE, in addition to the N, S, E, and W headings.
2 DO NOT COPY FROM OTHER WEBSITES Upvote guarenteed for a correct and detailed answer. Thank you!!!
Is there a need for greater research into Instagram's security in a distributed setting?
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) Please make the clock update in real-time Thank You
Draw a windows navigation diagram from the picture below.
Look at the following images and create a hastag based on the type of online threat represented by each image.
Please Help ASAP!!!
Read about the TOR browser and familiarize yourself with its working. In late 2022, researchers discovered malware called the OnionPoison which targets the TOR browser. More about this malware: https://www.kaspersky.com/about/press-releases/2022_onionpoison-infected-tor-browser-installer-distributes-through-popular-youtube-channel Using this and other sources, prepare a list of resources that would help a digital forensics professional discover if a computing device is infected by the OnionPoison.
Using android studio 1. Assume we have an activity named musicVideo, write the code to launch/start this activity. Paste the code in the box below. 2. In your own words what does the following code do? What is the name of the activity that will be displayed to the user? Button button = (Button) findViewById(R.id.btnLauncher); button.setOnClickListener(new View.OnClickListener() { public void onClick(View v) { startActivity(new intent(MainActivity.this, clothes.class)); } } 3. What is wrong with the following? Show your fixes below <string name=app_name">TestApp</string> <string name="txtTitle">Testing App<string> <string name="txtTimes">Times</string> </string name="prompt">Select Group</string> <string name="description">This app stores times</string> <string name"btnTimes">Display Times</string>
Is there a need for more research on the security of Instagram in a system that is decentralized?
When using JavaScript, what kinds of events might you expect? Make use of the onclick event by writing a script to demonstrate it.
I am trying to make a discord NSFW filter bot that:-Automatically removes messages that are flagged as inappropriate-Removes Content (Photos/Videos) that is flagged as NSFW-Warns players that the content they've sent has been removed/is sufficient for a ban from the serverA recent link or guide on how to would be great. I'm using Visual studio codeWHAT DOES "PROBLEM" MEAN? THIS WHOLE THING IS THE PROBLEM. I have no idea where to start, Any ideas help, links would be appreciated.