Use EDA to find impossible scenarios

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

Diese Übung ist Teil des Kurses

<Kurs>Writing Functions and Stored Procedures in SQL Server</Kurs>

Übungsanweisungen

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.

Interaktive praktische Übung

Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.

SELECT
	-- PickupDate is after today
	COUNT (CASE WHEN ___ > ___() THEN 1 END) AS 'FuturePickup',
    -- DropOffDate is after today
	COUNT (CASE WHEN ___ > ___() THEN 1 END) AS 'FutureDropOff',
    -- PickupDate is after DropOffDate
	COUNT (CASE WHEN ___ > ___ THEN 1 END) AS 'PickupBeforeDropoff',
    -- TripDistance is 0
	COUNT (CASE WHEN ___ = ___ THEN 1 END) AS 'ZeroTripDistance'  
FROM YellowTripData;

Code bearbeiten und ausführen