SQL · Capital One · Hard
A simplified airline on-time performance dataset lives in a single relational table named flights. Time-of-day values are kept as character data rather than native time types, and delay fields are stored as whole minutes. Before any model predicts arrival delay, the table has to be audited with SQL. Two separate audit queries are requested below, and both share the same output shape: issue_type — the rule label, chosen from the fixed list supplied for that audit.…
Checking your access…