Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
Imagine you’re an HR manager and want to get an overview of the average performance rating for each department
Home
Oracle
Imagine you’re an HR manager and want to get an overview of the average performance rating for...
0
votes
asked
Jan 23
in
Oracle
by
SakshiSharma
Imagine you’re an HR manager and want to get an overview of the average performance rating for each department. Write an Oracle SQL query to retrieve the department and the average performance rating for each department.
sql-query
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Jan 23
by
SakshiSharma
SELECT department, AVG(rating) AS avg_rating
FROM employees
GROUP BY department;
Related questions
0
votes
Q: Say you’re preparing a report for the management to identify employees who have shown consistently high performance.
asked
Jan 23
in
Oracle
by
SakshiSharma
sql-query
0
votes
Q: Imagine that you have a students table with the columns student_id, student_name
asked
Jan 23
in
Oracle
by
SakshiSharma
sql-query
0
votes
Q: You want to create a list of managers and the number of employees reporting to them
asked
Jan 23
in
Oracle
by
SakshiSharma
sql-query
0
votes
Q: Write an Oracle SQL query to find the average salary of employees within each department.
asked
Jan 21
in
Oracle
by
rajeshsharma
oraclesqlquery
0
votes
Q: Write the SQL query to get the third maximum salary of an employee from a table named employees.
asked
Nov 8, 2021
in
Sql
by
rajeshsharma
sql-query
0
votes
Q: Retrieve the top five highest-rated products based on customer
asked
Jan 21
in
Oracle
by
rajeshsharma
sql-query
0
votes
Q: Imagine you want to identify employees who are eligible for promotions based on their years
asked
Jan 23
in
Oracle
by
SakshiSharma
oracle-query
0
votes
Q: How to display employee records who gets more salary than the average salary in the department?
asked
Jul 29, 2020
in
Oracle
by
Hodge
#oracle
0
votes
Q: How to write an SQL query to find students' names start with 'A'?
asked
Nov 8, 2021
in
Sql
by
rajeshsharma
sql-query
0
votes
Q: _______________ can be explained as a Schema-free SQL Query Engine for NoSQL, Hadoop, and Cloud Storage.
asked
Apr 17, 2022
in
Apache Drill
by
sharadyadav1986
schema-free-sql
sql-query
...