Last answered:

10 Dec 2021

Posted on:

28 Oct 2021

0

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

Hello,
I get NULL value after running both the scripts but you had mentioned that we need to get 101 records. Please throw some light.

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

10 Dec 2021

0

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,

Submit an answer