1.Write a query to display the names of the employees that do not have any department_id.
2. Write a query to display the names, salary and job_id of employees in department_id 40, 60 and 80. Display the name as a single column and label it as Full_Names.
You will need the field definition of the employee table to get the correct answer, but it should look like this:
"SELECT name FROM employees WHERE department_id IS NULL;"
Replace the lowercase names by the field and table names.
You would benefit from following a tutorial, or reviewing your class notes.
An example tutorial for beginners is:
http://beginner-sql-tutorial.com/sql.htm
or a site with examples:
http://www.1keydata.com/sql/sql.html
For the second question, it would look something like:
COLUMN Full_name ALIAS CONCAT(TRIM(family_name),' ',TRIM(first_name));
SELECT Full_name,salary,job_id FROM employees WHERE department_id=40 OR department_id=60 OR department_id=80;
Having said that, I suggest you make an effort to write the query statements and post the problematic ones if there's any.
To answer the first question and display the names of employees who do not have any department_id, you can use the following SQL query:
```sql
SELECT name
FROM employees
WHERE department_id IS NULL;
```
This query uses the SELECT statement to retrieve the names of employees from the "employees" table. The WHERE clause is used to filter the results and only return the rows where the department_id is NULL (indicating no department assigned).
To answer the second question and display the names, salary, and job_id of employees in department_id 40, 60, and 80, with the name displayed as a single column labeled as "Full_Names," you can use the following SQL query:
```sql
SELECT CONCAT(first_name, ' ', last_name) AS Full_Names, salary, job_id
FROM employees
WHERE department_id IN (40, 60, 80);
```
This query uses the SELECT statement to retrieve the concatenation of the first_name and last_name columns as "Full_Names," along with the salary and job_id columns from the "employees" table. The WHERE clause is used to filter the results and only return the rows where the department_id is either 40, 60, or 80.