QuestionQ74

VerifiedPrepare data

You have a Fabric eventhouse that contains a KQL database. The database contains a table named TaxiData that stores the following data.

Question Image

You need to create a column named FirstPickupDateTime that contains the first value of each hour from tpep_pickup_datetime, partitioned by payment_type.

How should you complete the query?

Community Discussion

No comments yet. Be the first to start the discussion!