Hello. Can anyone please help me in this relational database MySQL.Use left outer join to write a qu

Hello. Can anyone please help me in this relational database MySQL.Use left outer join to write a query to show all person’s contact_id, first_name, last_name from mc_contacts table, and title, salary from job_current table. show NULLs if a person doesn’t have a job.A company needs a table to save its employee’s info.•       Write the sql to create one table: id, name, manager_id•       The boss’s manager_id is his own id.•       Write a query to show id, name,manager name.Write a query to show all the boys and girls name from boys and girls table.Attachment 1Attachment 2Attachment 3Attachment 41. Use left outer join to write a query to show all person’s contact_id, first_name, last_namefrom mc_contacts table, and title, salary from job_current table. show NULLs if a persondoesn’t have…