Solutions-Advanced Topics

 

37. Use

select count(*) from flight where date is null;

38. Use

select flight.*, bank_transaction.*
from flight, bank_transaction
where flight.date = bank_transaction.date;

39. The corresponding banking details are filled with null values.

Back to Tutorial