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

Related questions

Q: Create a java program for a AI Chatbot using chatgpt api. Include cool graphics and animations.

A: With the ChatGPT API, developing a Java program for an AI Chatbot with eye-catching graphics and…

Q: 4. How to display a border like this: Top border = 10 pixels Bottom border = 5 pixels The left…

A: Answer The syntax for the CSS border-width property (with 4 values ) is: border-width: top right…

Q: What characteristics make the game unique? Why is this game significant in the history of video…

A: Required: What characteristics make the game unique? Why is this game significant in the history of…

Q: Keyboard events are generated immediately when a keyboard key is pressed or released.

A: There are three types of keyboard event: Keydown Keyup Keypress

Q: is there any other feature to make the coulummns not visible besides hide.

A: Int his question we have to provide a technique in Excel to make the column not visible without…

Q: Consider the following lines of code: int test1 = 83; int test2 = 90; double average = (test2 +…

A: The answer for this "No"

Q: Describe the scenario when an application goes into an inactive state in Android?

A: Inactive state in android: It is that state in the android when user has opened the application but…

Q: is it possible to create a social distancing detection using ryze tello drone ? using python?

A: Social distancing detection system: It is a system that uses Drone to identify the distances…

Q: Watch the Think Media video “How a Car is built,” which details the production process for the…

A: Following are the snaps of the youtube videos:As a result, Ford Motor Company is known to be…

Q: Which statement best describes a slicer? Select an answer: A slicer is a page-level filter. A slicer…

A: This question come from paper of computer science. Let's discuss it in the next section of this…

Q: What types of events might you anticipate while utilising JavaScript? Write a script to show how to…

A: When utilizing JavaScript, there are various types of events that you might anticipate. Some common…

Q: \table [[, Q2, Q3, Q4], [,, Q7, Q8], [Q9, Q10, Q11, Q12], [Q13, Q 14, Q15,]] What is the name and…

A: In this structured representation, we have a table containing various items, each identified by…

Q: Image source: htps:www.avg.com/en'signaliwhat-ia-spyware image source: https:/tgc.comtagiadware BUY…

A: 1.#spyware 2.#adware 3.#worm or #virus 4.#phishing 5.#pharming

Q: Thank you! This showed up on my console, but how to I get it to appear in my html document? I have…

A: In this question we have to understand how to utilize external JavaScript script on the HTML page.…

Question

asap!!

Write SQL Queries for following Employee table :
EMPLOYEE_ID Name
EMAIL
HIRE_DATE SALARY DEPARTMENT
Juniad@abc.com | 2010-06-18
Irfan@abc.com
Hassan@abc.com 2010-03-08
Fahad@abc.com 2013-01-28
110000.00 CS
100000.00 Sales
88000.00 Marketing
101
Juniad
Irfan
102
2011-04-16
103
Hassan
104
Fahad
90000.00
Sales
105
Husnain Hus@abc.com
2012-01-28
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.
5. Write a query to select first 2 records from a table.
6. Write a query to get the name of employees ends with character 'N'. Such as Hassan etc.

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!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions

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
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.
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
11 and 12 DO NOT COPY FROM OTHER WEBSITES COrrect and detailed answer will be Upvoted else downvoted directly. Thank you!
Explain the W3Cks stated reasoning as to why was decided to stop maving all of CSS through version numbers as one cohesive Unit. Do you agree or disagree with this passion and wh For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac)
I have to make a tic-tac-toe game using HTML,CSS and Java Script. . I can make the game to my own preferences. You can make the game to your own liking as long as the game runs and uses HTML,CSS and JavaScript. Game needs to be created from scratch. Not copied off of another website please. Background and everything is completely up to the builder.