Sample DB Discrpency
Hi Sir,
While I was exploring the employees database used in the course practices I found that We have 240,124 employees with signed contract, meanwhile we have ONLY 101,796 employees on the payroll. Signed contract means that the from_date is '9999-01-01'. I think this is a discrpency that we need to fix or I am missing something.
Thanks,
Waleed
While I was exploring the employees database used in the course practices I found that We have 240,124 employees with signed contract, meanwhile we have ONLY 101,796 employees on the payroll. Signed contract means that the from_date is '9999-01-01'. I think this is a discrpency that we need to fix or I am missing something.
Thanks,
Waleed
1 answers ( 0 marked as helpful)
Hi Waleed!
Thanks for reaching out.
The employees in employees.sql, (not other SQL databases, such as employees_mod) are a little over 300,000.
Wherever you see '9999-01-01', this should be an end date (to_date). It is a way to mark a contract without a specified contract end date. Alternatively, you could use a word ('no end date') or '9999-12-31' (perhaps even more precise, theoretically), but that's the idea.
Hope this helps but please feel free to get back to us should you need further assistance. Thank you.
Kind regards,
Martin