1) To find out the names of employees who belong to the same department as Mark and have a salary greater than 50,000, you would need to perform a join operation on the two tables based on the emp_id, and then filter based on the conditions. Here is the SQL query:

```sql
SELECT e.name
FROM employees e
JOIN salaries s ON e.emp_id = s.emp_id
WHERE e.dept_id = (SELECT dept_id FROM employees WHERE name = 'Mark')
AND s.salary 50000;
```

2) To find out names of employees whose salaries are greater than 50,000, you would need to join the two tables and filter where the salary is greater than 50,000. Here is the SQL query:

```sql
SELECT e.name
FROM employees e
JOIN salaries s ON e.emp_id = s.emp_id
WHERE s.salary 50000;
```

3) To retrieve the names of employees who have a higher salary than John, you would need to join the two tables and filter where the salary is greater than John's salary. Here is the SQL query:

```sql
SELECT e.name
FROM employees e
JOIN salaries s ON e.emp_id = s.emp_id
WHERE s.salary (SELECT s.salary FROM salaries s JOIN employees e ON e.emp_id = s.emp_id WHERE e.name = 'John');
```

Question

1) To find out the names of employees who belong to the same department as Mark and have a salary greater than 50,000, you would need to perform a join operation on the two tables based on the emp_id, and then filter based on the conditions. Here is the SQL query:

```sql
SELECT e.name
FROM employees e
JOIN salaries s ON e.emp_id = s.emp_id
WHERE e.dept_id = (SELECT dept_id FROM employees WHERE name = 'Mark') 
AND s.salary > 50000;
```

2) To find out names of employees whose salaries are greater than 50,000, you would need to join the two tables and filter where the salary is greater than 50,000. Here is the SQL query:

```sql
SELECT e.name
FROM employees e
JOIN salaries s ON e.emp_id = s.emp_id
WHERE s.salary > 50000;
```

3) To retrieve the names of employees who have a higher salary than John, you would need to join the two tables and filter where the salary is greater than John's salary. Here is the SQL query:

```sql
SELECT e.name
FROM employees e
JOIN salaries s ON e.emp_id = s.emp_id
WHERE s.salary > (SELECT s.salary FROM salaries s JOIN employees e ON e.emp_id = s.emp_id WHERE e.name = 'John');
```

Knowee AI · Accepted Answer

1) To find out the names of employees who belong to the same department as Mark and have a salary greater than 50,000, you would need to perform a join operation on the two tables based on the emp_id, and then filter based on the conditions. Here is the SQL query:

```sql
SELECT e.name
FROM employees e
JOIN salaries s ON e.emp_id = s.emp_id
WHERE e.dept_id = (SELECT dept_id FROM employees WHERE name = 'Mark') 
AND s.salary > 50000;
```

2) To find out names of employees whose salaries are greater than 50,000, you would need to join the two tables and filter where the salary is greater than 50,000. Here is the SQL query:

```sql
SELECT e.name
FROM employees e
JOIN salaries s ON e.emp_id = s.emp_id
WHERE s.salary > 50000;
```

3) To retrieve the names of employees who have a higher salary than John, you would need to join the two tables and filter where the salary is greater than John's salary. Here is the SQL query:

```sql
SELECT e.name
FROM employees e
JOIN salaries s ON e.emp_id = s.emp_id
WHERE s.salary > (SELECT s.salary FROM salaries s JOIN employees e ON e.emp_id = s.emp_id WHERE e.name = 'John');
```

Question

Solution

Similar Questions

Upgrade your grade with Knowee