1. 학습
    2. /
  2. 강의
    3. /
  3. Writing Functions and Stored Procedures in SQL Server
Connected

연습 문제

Use EDA to find impossible scenarios

Calculate how many YellowTripData records have each type of error discovered during EDA.

지침

100 XP
  • Use CASE and COUNT to understand how many records contain the following errors:
  • DropOffDate before PickupDate, DropOffDate before today, PickupDate before today, TripDistance is zero.