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