Last answered:

10 Nov 2023

Posted on:

21 Oct 2023

0

information from the "salaries" table regarding contracts from 66,000 to 70,000 dollars per year

SELECT   * FROM     salaries WHERE salary BETWEEN 66000 AND 70000; 

I think that above query will retrieve per contract. But your question is for per year. So I think that need to calculate for each year salary first based on contract period. Is it right?


The salary from employees table is based on contract which period is sometimes more than one year.

Dear instructor, looking forward your answer.............

1 answers ( 0 marked as helpful)
Instructor
Posted on:

10 Nov 2023

0

Hi THET!

Thanks for reaching out.

This question has been treated in the SQL+Tableau course, Problem !!

To internalise our course material best, we advise to first complete the SQL and Tableau courses, and then move on to SQL + Tableau!

Hope this helps.

Kind regards,
Martin

Submit an answer