To answer your queries, we will use SQL (Structured Query Language), which is a standard language for managing data held in a relational database management system.

1) To find the employees who get a salary more than Chris, we first need to find out how much Chris earns. Then we compare this salary with the salaries of all other employees. Here is the SQL query for this:

```sql
SELECT empno, ename, salary
FROM EMP
WHERE salary (SELECT salary FROM EMP WHERE ename = 'Chris');
```

This query first finds the salary of Chris, then selects the employee number, name, and salary of all employees whose salary is greater than Chris's salary.

2) To display the department number along with the number of employees which belongs to that department number, we can use the GROUP BY clause in SQL. Here is the SQL query for this:

```sql
SELECT deptno, COUNT(empno) as num_of_employees
FROM EMP
GROUP BY deptno;
```

This query groups the employees by their department number, then counts the number of employees in each department. The result is a list of department numbers along with the number of employees in each department.

Question

To answer your queries, we will use SQL (Structured Query Language), which is a standard language for managing data held in a relational database management system.

1) To find the employees who get a salary more than Chris, we first need to find out how much Chris earns. Then we compare this salary with the salaries of all other employees. Here is the SQL query for this:

```sql
SELECT empno, ename, salary
FROM EMP
WHERE salary > (SELECT salary FROM EMP WHERE ename = 'Chris');
```

This query first finds the salary of Chris, then selects the employee number, name, and salary of all employees whose salary is greater than Chris's salary.

2) To display the department number along with the number of employees which belongs to that department number, we can use the GROUP BY clause in SQL. Here is the SQL query for this:

```sql
SELECT deptno, COUNT(empno) as num_of_employees
FROM EMP
GROUP BY deptno;
```

This query groups the employees by their department number, then counts the number of employees in each department. The result is a list of department numbers along with the number of employees in each department.

Knowee AI · Accepted Answer

To answer your queries, we will use SQL (Structured Query Language), which is a standard language for managing data held in a relational database management system.

1) To find the employees who get a salary more than Chris, we first need to find out how much Chris earns. Then we compare this salary with the salaries of all other employees. Here is the SQL query for this:

```sql
SELECT empno, ename, salary
FROM EMP
WHERE salary > (SELECT salary FROM EMP WHERE ename = 'Chris');
```

This query first finds the salary of Chris, then selects the employee number, name, and salary of all employees whose salary is greater than Chris's salary.

2) To display the department number along with the number of employees which belongs to that department number, we can use the GROUP BY clause in SQL. Here is the SQL query for this:

```sql
SELECT deptno, COUNT(empno) as num_of_employees
FROM EMP
GROUP BY deptno;
```

This query groups the employees by their department number, then counts the number of employees in each department. The result is a list of department numbers along with the number of employees in each department.

Question

Solution

Similar Questions

Upgrade your grade with Knowee