Select the average salary rounded to 2 decimal places from the `employees` table.

Problem Statement

<p>Select the average salary rounded to 2 decimal places from the <code>employees</code> table.</p>

Examples

Input: employees table: +----+---------+-----------+ | id | name | salary | +----+---------+-----------+ | 1 | Alice | 75000.567 | | 2 | Bob | 62000.123 | | 3 | Charlie | 88000.999 | +----+---------+-----------+

Output: +------------+ | avg_salary | +------------+ | 75000.56 | +------------+

Explanation: The query retrieves the requested records satisfying all problem requirements.

Complexity

Time Complexity: -

Space Complexity: -

Hints

💡 Hint 1: Carefully review the required fields in the table schema. 💡 Hint 2: Construct a clean SELECT statement specifying the requested columns or wildcard *. 💡 Hint 3: Structure: SELECT <columns> FROM <table_name>;

Editorial & Approach

Problem Overview & Intuition

To solve "ROUND Function", we query the relational database engine using declarative SQL. The goal is to select the average salary rounded to 2 decimal places from the `employees` table. By formulating an optimal execution plan with appropriate projection and filtering, the database engine executes the query with minimal overhead.

Step-by-Step Approach

Analyze Schema: Identify the target tables, necessary foreign keys, and expected output columns.
Construct Filtering & Logic: Apply row projections to isolate the requested data.
Format & Order: Ensure columns match the expected project schema in order.

Optimal Implementation (SQL)

SELECT ROUND(AVG(salary), 2) AS avg_salary FROM employees;

Complexity Analysis

Time Complexity O(N)

Space Complexity O(1)

Key Considerations & Edge Cases

Empty Tables: The query executes safely returning zero rows without syntax error.
NULL Values: Columns containing NULL values are properly handled by standard ANSI SQL semantics.
Case Sensitivity: String comparisons and keywords adhere to PostgreSQL/standard SQL rules.

ROUND Function

Easy

Select the average salary rounded to 2 decimal places from the employees table.

Example Scenarios

1Example 1

Input:

employees table

id	name	salary
1	Alice	75000.567
2	Bob	62000.123
3	Charlie	88000.999

Output:

avg_salary
75000.56

Explanation:

The query retrieves the requested records satisfying all problem requirements.

SQL Editor

Loading Editor...

Query Results

Run a query to see results here.