1. You must write all of the SQL (DDL statements) necessary to create all of the tables (relations) that you defined in the previous project.
2. You must write three complex SQL SELECT queries that each use JOIN to combine data from at least three different tables (these are up to you). One of the queries must JOIN four tables. All three SQL queries need to use a WHERE clause as well (I would keep the WHERE clause simple to only one comparison).
3. Include a brief statement that says what each SELECT query is intended to do.
4. Submit all of the SQL (both the queries needed to create your tables and the required SELECT queries) and the brief statements.

Using this ERD

please help me write code using mysql, using this erd to see the relations and follow steps 1-4

Hospital_Name Department ID County_JD Hospital ID Patient Record M IND City contains Hospital holds Emergency Department Doctor_ID Doctor Records stafts Iniury ID Patient Record Patient 10 Specialty M M M Injury_location Injury receives Patient treats Doctor Doctor Records Patient Name Patient ID Patient address Doctor ID Salary