How do I write this SQL query?

Prepare a issue to display the aspect of employees inside ‘Shipping’ office who were hired right after ’01-JAN 1990.Note which query must work with a join.

You need to know the structure in the tables helpful to store the info.

Usually, you’d want a WHERE clause to help filter for you to only those people hired immediately after 1/1/1990.electronic.g.

Such as, depending on the way the data is usually organized, the query would need to have at the least this element:

PICK OUT * FROM employees
WHERE dateHired > ‘1/1/1990’

As previous, it would assist in know the actual database schema.It’d also assist in know which in turn DBMS you will be using, since each tends to specify day literals in another way to.However, as a WAG, it’d probably be under the lines of

PICK OUT
VIA employee e JOIN office d IN e.deptID = ve had.deptID
WHERE departmentName = “Shipping”
AND hireDate > “#01/01/1990#”.