🙏 We really need your support. We need funding to continue our mission: publishing new lessons and improving the platform. If you can, please support the project with a donation. Help the project now →
SQL code copied to buffer
Task 19:

Dataset Quality Check

Create a brief quality report for the `yellow_tripdata` dataset. Return one row with the total number of records, the number of missing values in key columns, the number of records with an invalid distance, cost, passenger count, or time interval, and the percentage of records without detected problems. Consider a record problematic if the pickup or dropoff timestamp is missing, the distance is missing or not positive, the total cost is missing or negative, the passenger count is missing or not positive, or the dropoff time is earlier than the pickup time.

Use DuckDB syntax to write your answer. Descriptions of tables are provided in the right pane.

Write your request in the field below and click the "Check it!" button.
Get hint
Copy code Clear editor

Hi! Could we please enable some services and cookies to improve your experience and our website?

Privacy & Cookie Policy.