SQL_QUERY.txt

SELECT * FROM DASH103248.NYCTAXI_TRIPDATA as trip, DASH103248.NYCTAXI_FAREDATA as fare WHERE trip.MEDALLION = fare.MEDALLION AND trip.HACK_LICENSE = fare.HACK_LICENSE AND trip.PICKUP_DATETIME = fare.PICKUP_DATETIME ORDER BY RAND() FETCH FIRST 2000000 ROWS ONLY