(a) Consider a 'Painter Details' database with four tables as given below Table Name : Country Table Name : Painter country_code I country.name painter_num I painter_fname painter_gender country_code 10014 I josephine IT US 10015! rose 2 LUK 10016 I all 3 Malaysia 10017 I nadia 10018 | Itero 10019 I theresa 4 1 Singpore Table Name: Gallery gal_num | gal_name 18 I painter place 23 | arts US 24 | arts wonders Table Name: Paintings painting num painting_title I painter_num | gal_num 20018 | dawn thunder 10016 18 200231 vaniall roses 10015! 18 20041 | tired flounders 10016 i 23 20042 hasty exit 10015 24 20045 I plastic paradis 100151 18 21003 databse sunshin 10014 I 24 21005 I file system fol 10017 | 18 NINN v) Write an SQL statement that gives the painter name and nurr Jer of paintings he has done as given below PainterName i count(*) JOSEPHINE ROSE ALI NADIA HNW vi) Write an SQL statement to remove table 'Gallery'. Also write an SQL to remove the database 'painter_details'. Finally, write an sal statement to change the name of the table Painter' to 'Painter_Details'. vii) Write a stored procedure which gives list of painters belonging to the country 'US