Sure, here are the SQL queries for each of the given statements:

1) Display name of employees who belongs to Computer department.
```sql
SELECT ename
FROM Emp
WHERE dname = 'Computer';
```

2) Display employee id whose name starts from letter J.
```sql
SELECT eid
FROM Emp
WHERE ename LIKE 'J%';
```

3) Display all details of employees whose salary is from 10000 to 20000.
```sql
SELECT *
FROM Emp
WHERE salary BETWEEN 10000 AND 20000;
```

4) Display name of employees who are having maximum salary.
```sql
SELECT ename
FROM Emp
WHERE salary = (SELECT MAX(salary) FROM Emp);
```

5) Display name of employees whose salary is higher than average salary of the employee.
```sql
SELECT ename
FROM Emp
WHERE salary (SELECT AVG(salary) FROM Emp);
```

6) Display name of employees whose project id is 3 and location is Mumbai.
```sql
SELECT E.ename
FROM Emp E
JOIN Project P ON E.eid = P.eid
WHERE P.pid = 3 AND P.location = 'Mumbai';
```

Please note that the creation of tables with Primary Key, foreign key constraints in given schemas is not included in the above queries. You would need to create the tables first before running these queries.

Question

Sure, here are the SQL queries for each of the given statements:

1) Display name of employees who belongs to Computer department.
```sql
SELECT ename 
FROM Emp 
WHERE dname = 'Computer';
```

2) Display employee id whose name starts from letter J.
```sql
SELECT eid 
FROM Emp 
WHERE ename LIKE 'J%';
```

3) Display all details of employees whose salary is from 10000 to 20000.
```sql
SELECT * 
FROM Emp 
WHERE salary BETWEEN 10000 AND 20000;
```

4) Display name of employees who are having maximum salary.
```sql
SELECT ename 
FROM Emp 
WHERE salary = (SELECT MAX(salary) FROM Emp);
```

5) Display name of employees whose salary is higher than average salary of the employee.
```sql
SELECT ename 
FROM Emp 
WHERE salary > (SELECT AVG(salary) FROM Emp);
```

6) Display name of employees whose project id is 3 and location is Mumbai.
```sql
SELECT E.ename 
FROM Emp E 
JOIN Project P ON E.eid = P.eid 
WHERE P.pid = 3 AND P.location = 'Mumbai';
```

Please note that the creation of tables with Primary Key, foreign key constraints in given schemas is not included in the above queries. You would need to create the tables first before running these queries.

Knowee AI · Accepted Answer