Adobe Interview Question | Car Accidents

Question

Given two tables, one of customers and another of car accidents, write a SQL query to get the top car accidents by day.

(Hint- Assume the missing data)

in progress 0
Dhruv2301 55 years 1 Answer 965 views Great Grand Master 0

Answer ( 1 )

  1. Naman2907
    0
    Reply

    We can group the data as per days and then apply the First_value window function to get the car which had accident first each day.

Leave an answer

Browse
Browse