PLEASE GIVE ME THE CORRECT ANSWER!!!!!!!!!!!!!!!

1.Get supplier names for suppliers who supplied for job J2. (Use a nested query)

2. Get supplier names for suppliers who supplied parts for jobs only in Athens. (Use a nested query)

3. Get part names for parts that are not supplied for job J3. (Use a nested query)

4. Which city has the most suppliers? (Use a nested query)

5.Calculate each suppliers total sales quantity and get the sales persons name if the sales person supplies parts more than 1000 units in total.

6. Get job numbers for jobs whose city is first in the alphabetical list of the job cities.

7. Increase the status values of suppliers by 5 who are located in Paris.

Please hand in the modified table and the query.

Please create following tables by using MySQL and answer the following questions Submit a table creation script and data insert script. Then prepare the report as follows: question number, question, SQL statement and the result table for each question. city namecolor weight city Red Green Blue Red Blue Red 12 17 Paris 17 Rome Reader onsole ollator Terminal 12 Paris ape qty 200 700 400 200 200 500 600 status city mith 20 10 Paris 30 Paris 20 30 Athens Blake 800 100 200 500 300 300 100 200 100 200 800 500 100 200 500 Please create following tables by using MySQL and answer the following questions Submit a table creation script and data insert script. Then prepare the report as follows: question number, question, SQL statement and the result table for each question. city namecolor weight city Red Green Blue Red Blue Red 12 17 Paris 17 Rome Reader onsole ollator Terminal 12 Paris ape qty 200 700 400 200 200 500 600 status city mith 20 10 Paris 30 Paris 20 30 Athens Blake 800 100 200 500 300 300 100 200 100 200 800 500 100 200 500