Write SQL Queries for following Employee table : EMPLOYEE_ID Name EMAIL HIRE DATE SALARY DEPARTMENT 101 Juniad Juniad@abc.c 2010-06-18 110000.0 CS om 102 Irfan Irfan@abc.co 2011-04-16 100000.0 Sales 103 Hassan Hassan@abc. 2010-03-08 88000.00 Marketing com 104 Fahad Fahad@abc.co 2013-01-28 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.

Write SQL Queries for following Employee table : EMPLOYEE_ID Name EMAIL HIRE DATE SALARY DEPARTMENT 101 Juniad Juniad@abc.c 2010-06-18 110000.0 CS om 102 Irfan Irfan@abc.co 2011-04-16 100000.0 Sales 103 Hassan Hassan@abc. 2010-03-08 88000.00 Marketing com 104 Fahad Fahad@abc.co 2013-01-28 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.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Q: Using the the Employees table below write an SQL query which displays Last Name, First Name and how…

A: As per the table above, we have the ID, LastName, FirstName, Birthdate, Payrate, and HoursWorked…

Q: question 9 please use the picture below to answer the following question Write a SQL statement to…

A: Query: The below query is used to create a table named “new_Invoice” which is exactly the same as…

Q: Create the following table in your database with the following schema: Table: Sales | Column Name |…

A: Create a table Sales: CREATE TABLE Sales ( sale_id int, product_name varchar(255),…

Q: 5. Write a query to get the total salaries payable to employees. 6. Write a query to get the…

A: Sorry, we are supposed to answer only three subparts of question ad kindly resubmit the remaining…

Q: Instructions: Write the suitable SQL statement to answer the following questions based on the…

A: Answer: SELECT DEP_NO, COUNT(*) FROM Employee GROUP BY DEP_NO;

Q: SQL FOR THERES TABLES

A: To write SQL query for the given table

Q: Create a table based on EMP and DEPT tables such that it list each employee’s name, job, hire date,…

A: Given two tables: emp- empno, ename, job, mgr, hiredate, sal, comm, deptno dept- deptno, dname,…

Q: From each sales rep, list the rep number, description, number ordered and storehouse from their…

A: Select rep.rep_num, itm.description, ord.order_num,item.storehousefrom rep rep,customer cust, orders…

Q: Write the SQL code required to list the first name and last name of all customers whose middle…

A: Writing the SQL code required to list the first name and last name of all customers whose middle…

Q: 1. How many reviews for every product?

A: Let us suppose that the table is created as given below: create database DB; use DB; create table…

Q: For each department with more than one member of employee, find the sum of reward amounts for each…

A: The question is solved in step2

Q: Write a SQL statement to create a foreign key in table Invoice_Detail that refers to the…

A: Write a SQL statement to create a foreign key in table Invoice_Detail that refers to the…

Q: Given the table, EMPLOYEES below with the following rows, how many rows are generated by the SQL…

A: c. 1

Q: Write a SQL query to display product name and list price for products in category 1 which have the…

A: Sql Query:-

Q: which is more accurate? and are they even right?

A: The question has been answered in step2

Q: Write the SQL code to generate the total hours worked and the total charges made by all employees.…

A: See the explanation section for a complete answer.Explanation:To calculate the total hours worked…

Q: Using the EMP_2 table, write the SQL code that will add the attributes EMP_PCT and PROJ_NUM to…

A: The question is asking for an SQL command that will add two new columns to an existing table named…

Question

100%

Write SQL Queries for following Employee table :
EMPLOYEE_ID Name
EMAIL
HIRE_DATE SALARY DEPARTMENT
101
Juniad Juniad@abc.c 2010-06-18 110000.0 CS
om
102
Irfan
Irfan@abc.co 2011-04-16 100000.0 Sales
103
Hassan Hassan@abc. 2010-03-08 88000.00 Marketing
com
104
Fahad
Fahad@abc.co 2013-01-28 90000.00 Sales
m
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

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Trending now

This is a popular solution!

Step by step

Solved in 9 steps with 7 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

With SQL code, find the name of each employee with a manager along with their manager's name (use cartesian product and rename) Employee table: create table employee( ID varchar(6) not null,person_name varchar(10),street varchar(10),city varchar(10),primary key (ID)); Manages table: create table manages(ID varchar(6) not null,manager_id varchar(6),primary key (ID),foreign key (ID) references employee,foreign key (manager_id) references employee);
Based on the given table. Customer ID Name Balance Payment 193 Chen 2100 300 584 Ravindran 5000 250 231 Bolt 300 20 608 Gomez 950 125 What values are returned while the given query is executed? SELECT 2* (Balance - Payment) FROM Customer; 3900, 9750, 590, 1775 3600 3600, 9500, 560, 1650
Instructions: Write the suitable SQL statement to answer the following questions based on the following tables ( image for better table) Table Name: Employee EMP_ID FNAME LNAME SALARY JOIN_DATE DEP_NO 101 John Abraham 10000 01-JAN-13 11 202 Michael Clarke 80000 01-JAN-13 22 303 Roy Thomas 70000 01-FEB-13 11 404 Tom Jose 60000 01-FEB-13 22 505 Jerry Pinto 65000 01-FEB-13 22 606 Philip Mathew 75000…
I need help with this SQL query: Write a MySQL statement to create a table named jobs including columns job_id, job_title, min_salary and max_salary, and check whether the min_salary amount is lower than the lower limit $15,000 and whether the max_salary amount exceeds the upper limit $50,000.
use sql please List only the movies that have a value for gross (not NULL values). Include all columns in the result set.
Write the sql query to create given table.
SQL FOR THERES TABLES
Need help writing SQL queries for sample data base
sql code sql code sql code
Please use MySQL language and mySQL as server
16. please use the picture below to answer the following question Write a SQL statement to display Invoice Number and total sale for each Invoice.
Write SQL query to add default value 1000.