Continue from this part:

https://www.chegg.com/homework-help/questions-and-answers/continue-part-section-https-wwwcheggcom-homework-help-questions-answers-urgent-deadline-cl-q87619456

Can you please help me with section B questions 8, 9, and 10 (You are allowed to use MySQL Workbench. You may choose to create your tables listed under Section B to write your queries. Code execution is not compulsory):

PLEASE DO NOT USE ANSWERS TO OLD QUESTIONS. ANY ANSWERS THAT ARE NOT RELEVANT TO THE QUESTION BEING ASKED WILL BE REPORTED.

Section-B (30 marks) Using the tables and data descriptions provided below, answer the questions below. Put your final answers into the answer document you use to answer Section-A and Section-C. You do not have to show the execution results of your queries. Table description for Artist Column-Name Artis IPKI Artist Name Artist Country Comments/Description A unique identifier for the artist The name of the artist The country of the artist Table description for PaintingTyne Column-Name PaintingTypeID IPK PaintingTypeName Comments/Description A unique identifier for the painting type The name of the painting type Table Name for Painting Column-Name Comments/Description Painting IPKI A unique identifier for the painting PaintingName The name of the painting Painting Zype D EN FK referencing PaintingTypeID in Painting Type Table Artist FK FK referencing ArtistiD in Artist Table Please note you are tot allowed to use the "Natural Join" koryword for any of the questions 1. Write an SQL statement to create a table using the description below. You can use a data type of your choice Table Name: Exhibition Column-Name Comments/Description ExhibitionID. IPKI A unique identifier for the exhibition ExhibitionDate [PK] The date of the exhibition ArtistID FRI FK referencing Artist in Artist Table Exhibition Cost The entry fee of the exhibition (maximum cost could be $999.99 Noter Aneschibition features a single artist at a time 2. Provide an insert table statement for every table (Artist, Painting type, Painting and Exhibition) Use your name as the Artist's name. 3. Write a query that uses wildcard operators to print the ids and names of the Artists from countries that have 'g' as the third character in their name (eg England) 4. Write a query to print the names of the painting and the name of their types using a fin using command 5. How many paintings have each of the artists created? Your result should include the names of artists and the total number of paintings. Also include artists who have no paintings yet Sort the results by the highest number of paintings 6. Extend question 5 above to include only the artists who have more than the average number of paintings. (Note: You cannot use a LIMIT function.) 7. How many exhibitions have featured artists whose painting type is acrylic-related (You will have to use a wildcard operator here) have been produced 8. Using a subquery, print the names of the artists who produce watercolour art. 9. Using a join-on (instead of a subquery), rewrite question 1. 10. Print the details of the exhibition along with the names of the artist that were held in the first quarter of 2019 with an entry fee between $500 - $750 Section-B (30 marks) Using the tables and data descriptions provided below, answer the questions below. Put your final answers into the answer document you use to answer Section-A and Section-C. You do not have to show the execution results of your queries. Table description for Artist Column-Name Artis IPKI Artist Name Artist Country Comments/Description A unique identifier for the artist The name of the artist The country of the artist Table description for PaintingTyne Column-Name PaintingTypeID IPK PaintingTypeName Comments/Description A unique identifier for the painting type The name of the painting type Table Name for Painting Column-Name Comments/Description Painting IPKI A unique identifier for the painting PaintingName The name of the painting Painting Zype D EN FK referencing PaintingTypeID in Painting Type Table Artist FK FK referencing ArtistiD in Artist Table Please note you are tot allowed to use the "Natural Join" koryword for any of the questions 1. Write an SQL statement to create a table using the description below. You can use a data type of your choice Table Name: Exhibition Column-Name Comments/Description ExhibitionID. IPKI A unique identifier for the exhibition ExhibitionDate [PK] The date of the exhibition ArtistID FRI FK referencing Artist in Artist Table Exhibition Cost The entry fee of the exhibition (maximum cost could be $999.99 Noter Aneschibition features a single artist at a time 2. Provide an insert table statement for every table (Artist, Painting type, Painting and Exhibition) Use your name as the Artist's name. 3. Write a query that uses wildcard operators to print the ids and names of the Artists from countries that have 'g' as the third character in their name (eg England) 4. Write a query to print the names of the painting and the name of their types using a fin using command 5. How many paintings have each of the artists created? Your result should include the names of artists and the total number of paintings. Also include artists who have no paintings yet Sort the results by the highest number of paintings 6. Extend question 5 above to include only the artists who have more than the average number of paintings. (Note: You cannot use a LIMIT function.) 7. How many exhibitions have featured artists whose painting type is acrylic-related (You will have to use a wildcard operator here) have been produced 8. Using a subquery, print the names of the artists who produce watercolour art. 9. Using a join-on (instead of a subquery), rewrite question 1. 10. Print the details of the exhibition along with the names of the artist that were held in the first quarter of 2019 with an entry fee between $500 - $750