🚀 go-pugleaf

Beste mensen,

Kan er voor mij iemand de SQL opgaven oplossen voor mij want ik wil ze
vandaag instuderen. Je moet telkens SELECT..FROM..WHERE..ORDER
BY...GROUP BY... HAVING gebruiken.

5. Display the employee number, last name and salary increased by 15 %
and expressed as a whole number.

SELECT e.employee_id, e.last_name, e.salary
FROM EMPLOYEE e
WHERE ..... ?

6. Display the employee last name and function in parentheses for all
employees.

SELECT e.last_name, j.function
FROM EMPLOYEE e, FUNCTION j
WHERE ....?

7. Display the product name of products that have "BAKETBALL" in the
description.

SELECT p.description
FROM PRODUCT p
WHERE ....?

8. For each employee, calculate the number of months between today and
the date the employee was hired. Order the result by the number of
months employed. Round the number of the months up to the closest
whole number.

SELECT ....
FROM ....
WHERE ....?
ORDER BY

9. Display the last_name for all employees and the day of the week
they were hired. Order the results by the day of the week.

SELECT e.last_name, e.hire_date
FROM EMPLOYEE e
WHERE ....?
ORDER BY ....

10. Write a query that produces the following for each employee.
<employee last name> earns <salary> monthly but wants < 3 times
salary>

SELECT ....
FROM...
WHERE ...

Vriendelijk bedankt voor het oplossen van mijn vraagjes.
Ps: Ik wens oplossingen en gene zever want soms hangt het hier de
spuitgaten uit van al die tieners en kinderen op Internet
Ik help ook mensen als het kan want ik ben zeergoed thuis met de
hardware van PC's, Internet en toepassingen, Computernetwerken (niet
ontwerpen), en programmeren maar iedereen heeft telkens vragen