CREATE TABLE `contact_interest` ( id int not null auto_increment PRIMARY KEY, `contact_id` int(11) NOT NULL, `interest` varchar(50) NOT NULL,...

Hello. Can anyone please help me in this relational database MySQL.

1. 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.
2. 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.

1. Write a query to show all the boys and girls name from boys and girls table.

• Attachment 1
• Attachment 2
• Attachment 3
• Attachment 4

1. 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...