Not getting desired output on both the queries rather than 'NULL' in two columns.

Hi Bhushan!

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.
Best,