Solutions - Advanced Topics

  1. Use

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

    select flight.*, bank_transaction.*
    from flight, bank_transaction
    where flight.date = bank_transaction.date;
    
  3. The corresponding banking details are filled with null values.

Back to Tutorial