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;

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: Display the list of students who are involved in the IT club Display the details of all the…

A: First get the studid from Club table and then get those Student details This can be done using inner…

Q: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A: Answer :-- Jan-12-01

Q: Write the T-SQL scripts for the following tasks: - Write a query to list all the Employee's details…

A: let us see the answer:- Introduction:- We are going to use a select query to list all the Employees…

Q: Write SQL queries to answer the following questions:a. Which studen ts have an ID number that is…

A: SQL queries are given below

Q: Use CASE statement in PL SQL block, where take a character as input from the user and print…

Q: SELECT TO CHAR (DOB, 'DD/YY/MM') FROM patients WHERE Medical_no=1001;

A: Given: select TO_CHAR(DOB,'DD/YY/MM) from patients WHERE Medical_no = 1001. Explanation this is…

Q: Write function which hides the first_name, middle name and last_name and gives the joined version */

A: Find the required answer given as below :

Q: t the title of all books in the same category as books previously purchased by customer 1007. Don’t…

A: Lets see the solution.

Q: Write the T-SQL scripts for the following tasks: Write a query to select the employees whose…

A: Please refer to the following step for the complete solution of the problem above.

Q: Schema: Employees (EmpID int, Name varchar(50), Age int, Salary float, DepartmentID int)…

A: HI THERE,I AM ADDING ANSWER BELOWPLEASE GO THROUGH ITTHANK YOU

Q: Explain the benefits of using the identity column capability in SQL.

A: The identity column generates the key values. It makes the increment in the unique values.

Q: Write SQL statements to list the name of Lee’s subordinate employee. (Data Update) Write…

A: Lees Employee ID is 2 So, to get the lees subordinate then we need to search for this employee ID in…

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: Type in all the various types of numeric information. In SQL

A: SQL has various data types and numeric information is one of them. SQL contains various numeric…

Q: Question 1: Show (in one table) customer id and first name from Customers table together with…

A: SOLUTION -1)Query -SELECT CT.customer_id, CT.first_name, ST.shipping_id, ST.statusFROM Customers AS…

Q: Write all the sql code (including create, insert and select)

A: #use the below query to create users tablecreate table users(account int primary key,name…

Q: USE MY SQL List all the data in your table movie_prod, sorted by the id of the movie (smallest…

A: MySQL is based on the SQL programming language and allows developers to store, organize, and…

Q: Explain the use of SQL's identity column саpability.

A: To be determine: Explain the use of SQL's identity column capability.

Q: Difference between procedure and function in SQL

A: SQL functions and procedures are database objects designed to streamline and improve the…

Q: Type in all the various kinds of numbers. In SQL

A: 1) SQL stands for Structured Query language. It is a standard language for storing, manipulating and…

Q: by using the table in the query attached: Show the name, contact number and email address of the…

A: Demo data has been used to solve the query The SQL query is given below with output screenshot

Q: Customers Customer ID Last Name C0001 Faulkner C0002 Wit Loan Id L0010 L0017 L0016 Customer Total…

A: CustomerID Last Name Loan ID Amount C001 Faulkner L0010 200000 L0017 100000…

Q: True or FalseString comparisons in SQL are case sensitive.

A: Explanation: The data in DBMS is stored and retrieved by using a specific language called SQL. DBMS…

Q: Write an SQL query to add constraint unique to the column Product. (Using Constraint name…

A: Syntax for adding unique constraint on table. Alter table tableName add constraint constraintName…

Q: the HR department needs the department name, manager first name, manager last name, and job title.…

A: SQL: SQL stands for Structuref Query Language. It is used to access and manipulate the database…

Q: How do you determine the order in which the rows in a response to an SQL query appear?

A: GIVEN: How do you determine the order in which the rows in a response to an SQL query appear?…

Q: „By using SQL language return the

A: According to the question we need to return the items and their total number of units that have been…

Q: a) Find department_id for departments that do not contain the job id ST_CLERK a) lists the employee…

A: In this question we have to provide the SQL code for the following queries. Let's query and hope…

Q: The following SQL clause(s) are not permitted to be used in a subquery in the WHERE or HAVING…

A: Multicolumn subqueries cannot use the <, >, <=, >= comparison operators.

Q: Q3: How many unique titles do we have in the employee table? Hint: You need to create TWO queries,…

A: 1) SELECT DISTINCT titles FROM EMPLOYEE

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: Use SQL Developer or Oracle Live SQL to write the appropriate SQL commands as follows: a) Group all…

A: Process To display the all the data we use select * from tablename and condition what we want to get…

Q: USE NORTHWIND DATABASE Write a SELECT statement using the CASE function. The statement returns two…

A: sql select statement for above question is shown in step2

Q: Write the following as MySQL query: Find the department name whose location (Country_ID) is DE. Use…

A: SQL, which stands for Structured Query Language, is a domain-specific programming language used for…

Q: List at least 3 differences between Oracle PL/SQL programming functions and procedures (Differences…

A: Differences between Oracle PL/SQL programming functions and procedures S.N. function…

Q: Explain what the following SQL command does? SELECT * FROM employee LIMIT…

A: Structured Query Language: SQL stands for Structured Query Language and is a programming language…

Q: The only required sections of a PL/SQL block are DECLARE and END. Answers: Yes No

A: Given:

Q: 1. Prepare a list of orders by Shipper showing the Shipper ID, Order ID, Product ID and Quantity.…

A: In this question we have to understand about given SQL database and prepare the list of queries…

Q: Enter all the various kinds of numbers. In SQL

A: Numbers can be either accurate or approximative in SQL. The precise data types for numbers are…

Q: „By using SQL language return the items and their total number of units that have been ordered…

A: We have to pick the items where item name is not Pen and sum of Units of each Item category

Question

Need emergency answer. Don't reject.

First fill the above image table and answer the following questions with SQL code

SALARY
DOJ
BRANCH
oduction 45000
12-Mar-00 Bangalore
HR
70000
03-Jul-02
Bangalore
anagemer 120000
11-Jan-01
mysore
67000
01-Aug-01
mysore
145000 20-Sep-03
Mumbai
EMPNO EMP_NAME DEPT
E101
Amit
E102
Amit
E103
sunita
E105
sunita
IT
E106
mahesh Civil
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
6. Retrieve total salary of employee group by employee name and count similar names
7. Retrieve total salary of employee which is greater than >120000
8. Display name of employee in descending order
9. Display details of employee whose name is AMIT and salary greater than 50000;

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: 1. Display all the fields of employee table

VIEW

Step 2: 2. Retrieve employee number and their salary

VIEW

Step 3: 3. Retrieve average salary of all employees

VIEW

Step 4: 4. Retrieve number of employees

VIEW

Step 5: 5. Retrieve distinct number of employees

VIEW

Step 6: 6. Retrieve total salary of employees group by employee name and count similar names

VIEW

Step 7: 7. Retrieve total salary of employees which is greater than >120000

VIEW

Step 8: 8. Display name of employee in descending order

VIEW

Step 9: 9. Display details of employee whose name is AMIT and salary greater than 50000

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 10 steps

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

How can the CAST function be combined with other functions to enhance data type compatibility in SQL queries?
5. Display the current day of the week, hour, minutes, and seconds of the current date settingon the computer you’re using. SQL commands
Write the required SQL statements to create the PET_2 table
List the names of the production companies and the titles of their movies. This time, include all production companies. Sort alphabetically by the production company name. use sql ( so there a table of 'movie' and a table of 'production')
Answer the following questions based on the information in the PATIENT table below. Write SQL queries statement and provide the output of each query. (Screenshot the interface in MySQL that show SQL statement and output for each question). PATIENT PID PNAME AGE ADATE 1001 JAMAL 35 2000-10-28 M 1002 TAN 52 2000-11-20 M GENDER 1003 MARIAM 30 2000-07-16 F 1004 JOE 27 2000-12-18 M 1005 SOFEA 19 2000-04-25 F 5. List all patient details who are not same age as Jamal
From the Salesm an and Customer tables below, write SQL statements to do the following: a) List the sales man id, rating and names of those sales men who getrating from 3 to 5, sorted DESCENDING by rating. b) List all the customers' informat ion whose name starts with 'F' and the fourth character is T, rests may be any charac ter. c) List the name andcountry of those customers and sales men who belongs to the same country. Salesman table: Salesman Salesman_ rating _id country name 2001 Mc Lyon 3 Italy 2005 James hood 2 Canada 2045 Paul Hen USA 2010 Nail Alex 4 France 2060 Salm E 5 KSA Cust omer table: Cust_id Cust_nam grade country Salesman e _id 1 Nick 100 France 2010 Rimando 2 Brad Davis 400 Canada 2005 3 Fabian 200 Japan 2045 Johnson 4 UK Jozy Altidor 100 2010 5 Brad Guzan 500 Canada 2005
Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients MEDICAL NO FIRST NAME SUR NAME BLOOD TYPE PCR TEST DOB GENDER PHONE FAX WEIGHT SMOKER 1001 Said Alalawi 12-Jun-2001 Male 98877445 22114454 A 68 NO Negative 1002 Othman Mualla 20-Apr-2000 Male 78 YES Positive 1003 Sameera Bader 19-Oct-2005 Female 25541122 52 NO Positive 1004 Fahad Alhinai 24-Feb-2004 Male 91122544 AB 66 YES Negative 1005 shamsa Alfahdi 15-Sep-2002 Female 35 NO Negative SELECT NVL2 (phone, fax, 0) FROM patients WHERE medical no = 1005; Answer:
Enter all of the different sorts of numerical data. In SQL
Based on the picture please help me write an SQL querey for each (don't answer the actual question just please write an SQL querey) Write an SQL Query to list the name(s) and address(es) of employees who work at the department named- 'Human Resources’? (Hint: Use Table Joining) Write an SQL Query to list the names of all projects run by the department – ‘IT Transformation’? (Hint: Use Table Joining) Write an SQL Query to list the department number and the count of projects in each of these departments and only display those values that has more than 3 count. Rename the count column as ‘Project Count’. (Hint1: Use GROUP BY and HAVING. You need not use table joining) (Hint2: It is OK to see an empty outcome as long as your query is correct) Write an SQL Query to count unique ‘Female’ employees who have been designated as ‘Staff’ and also have worked for more than 20 hours on a single project? Rename the count value as ‘Employee Count’ (Hint: Use Table Joining).
Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients MEDICAL NO FIRST NAME SUR NAME DOB GENDER BLOOD TYPE PCR TEST PHONE FAX WEIGHT SMOKER 1001 Said Alalawi 12-Jun-2001 Male 98877445 22114454 68 NO Negative 1002 Othman Mualla 20-Apr-2000 Male 78 YES Positive 1003 Sameera Bader 19-Oct-2005 Female 25541122 52 NO Positive 1004 Fahad Alhinal 24-Feb-2004 Male 91122544 AB 66 YES Negative 1005 Shamsa Alfahdi 15-Sep-2002 Female 35 NO Negative SELECT COALESCE (phone, fax, 9999) FROM patients WHERE blood_type='A'; Answer:
Enter all of the various kinds of numerical information. In SQL
QUICK SQL REQUEST (beginner level...) Back at work on Monday morning, the Vice President of Purchasing asks you to help him with the analysis of in-process storage. He asks you to pull information regarding the number of products per storage location. The result of the query should show: - The name of the warehouse (Location) - The number of different products per storage location - The total quantity of products found at this storage location - The average price of all products found at this storage location He mentions that for the moment he is only interested in the locations that have more than 50 distinct products because he wants to start inventorying the biggest locations first. Show the locations in order of smallest to largest number of distinct products. My request is linked to the question but i'm having trouble executing it I would love to know how to do it, thanks in advance.