Question: $15/16$

SQL Server

Consider the attached schema below.

For all Accidents Registered, find whether there existed an active policy on the date of accident occurred $($mentioned in table as acc$\_$date$\_$time$),$ if exists show the Claim Status as Claim Approved else $($if no active policies$)$ show the Claim Status as Claim Rejected. Display Accident ID$,$ Car ID$,$ Claim Number, and Claim Status.

Note:

You can qurry the tables by entering your query and pressing on "Run SQL$.$ For example: "select $*$ from Policy"

Use only inner join unless explicitly instructed to do an outer join

You must return the exact expected columns in the specified order.