Hello, I need help writing the SQL statements in 6, 6a, 6b,6c,6d

thank you for your help and your time in advance

1) Use MySQL environment, such as provided by https:/www.tutorialspoint.coml coding ground MySOL, to create DB called rgv with the following tables using the commands given below (as demonstrated in the previous class... in case of typos debug and fix the typos) person works I pname city I pname company l ben I jenny bville I jenny Bankl I ben I edin ISD3 I harlingen I jenny NPS | ana sam bville NPS ana MariaDB [(none)> create database rgv; MariaDB [(none)> use rgv; MariaDB [rgv]> use rgv; MariaDB [rgv> create table person (pname VARCHAR(10) NOT NULL, city VARCHAR(10) NOT NULL, Primary Key (pname)) MariaDB [rgvj> create table works (pname VARCHAR(10) NOT NULL, company VARCHAR(10) NOT NULL, Primary Key (pname,company)) 6a) Using SQL, list the persons who work for a company located in edin 6b) Using SQL, list the persons who work for the company that jenny works for (hint: consider using in): 6c) Using SQL, list the persons who are not working (hint: consider using not in): 6d) Using SQL, list the persons who work for a company located in the city that they live in