[Solved]Given Following Sql Schema Someone Help Following Sql Coding Questions Question 4 Finished Q37071336

given the following SQL schema can someone help me with thefollowing SQL coding questions

Question 4: All the finished jobs on last week with the numberof deliveries.
Question 5: List of Brendan’s cancelled jobs (driver id=1858) lastweek for Nike ( client id = 566).
Question 6: Number of deliveries over 2 miles completed by bikes(transport type id= 2) the 21st of March in London.
Question 7: Email of the driver who did the largest number ofdeliveries over the past week for each transport type.
Question 8: Drivers who did 10 jobs or more within 7 days aftertheir onboarding (driver created at).

please help !!

delivery transport_type id job_status_type_id client start inviting_at last invitation sent at invitations count last_delivery_status_id destination_signature client_industry created at updated_at client size origin_place id destination place_id timestamp timestamp package_size JOB STATUS TYPE ID Transport type id Driver work mode Transport type Bike Car varchar created at updated_at 10 Show transcribed image text delivery transport_type id job_status_type_id client start inviting_at last invitation sent at invitations count last_delivery_status_id destination_signature client_industry created at updated_at client size origin_place id destination place_id timestamp timestamp package_size JOB STATUS TYPE ID Transport type id Driver work mode Transport type Bike Car varchar created at updated_at 10

Expert Answer

---

Answer to given the following SQL schema can someone help me with the following SQL coding questions Question 4: All the finished … . . .