Not getting desired output on both the queries rather than 'NULL' in two columns.
I get NULL value after running both the scripts but you had mentioned that we need to get 101 records. Please throw some light.
Thanks for reaching out!
It seems that your tables are empty.
You can try the following command to check:
SELECT * FROM employees;
If this table contains records, then check for the others. If some of the tables does not contain any records then you have to run the big database employees.sql to fill these tables with records.
Hope this helps.