Question 8: Create a view ('ActiveHiresWithInsurance') to show active hires with insurance details (show HireID, Date, PolicyType, and Cost), between the dates 5th of Jan 2024 and 25th May 2024, and for all insurance entries with a cost of more then $20.

Avoid joining insurance with Insurance ip ON hv.insuranceID = ip.insuranceID, it will result in hv not having insuranceID column

I tried checking with this query and wasting another 0.1 point only to find out HiredVehicle only contains HireID Date CardType CardNo Odometer Days VehicleID

CREATE VIEW IF NOT EXISTS ActiveHiresWithInsurance AS
SELECT hv.*
FROM HiredVehicle hv;

I don't know the name of the weak entity to link it to HiredVehicle so if anyone found it please also drop it down below