Please show in SQL code

INPUT& OUTPUT (Screenshots)

For each of the assigned problems, write a SQL query to retrieve the required information and test the query in MySQL

Premiere Products Database: Problems 1-10

Exercises Premiere Products Use MySQL to make the following changes to the Premiere Products database (see Figure 1-2 in Chapter 1). After each change, execute an appropriate query to show that the change was made correctly. Use the notes at the end of Chapter 3 to print your output if directed to do so by your instructor 1. Create a NONAPPLIANCE table with the structure shown in Figure 6-18. NONAPPLIANCE Length Decimal Places Nulls Allowed? Description Column PART_NUM DESCRIPTION CHAR ON HAND CLASS PRICE Type No Part number (primary key) Part description Number of units on hand Item class Unit price CHAR 15 DECIMAL CHAR DECIMAL FIGURE 6-18 NONAPPLIANCE table layout 2. Insert into the NONAPPLIANCE table the part number, part description, number of units on hand, item class, and unit price from the PART table for each part that is not in item class AP 3. 4. In the NONAPPLIANCE table, change the description of part number AT94 to "Deluxe Iron." In the NONAPPLIANCE table, increase the price of each item in item class SG by 2%. (Hint Multiply each price by 1.02.) 5. Add the following part to the NONAPPLIANCE table: part number: TL92; description: Trimmer; number of units on hand: 11; class: HW; and price: 29.95. 6. Delete every part in the NONAPPLIANCE table for which the class is SG. 7. In the NONAPPLIANCE table, change the class for part FD21 to null. 8. Add a column named ON HAND VALUE to the NON APPLIANCE table. The on-hand value is a seven-digit number with two decimal places that represents the product of the number of units on hand and the price. Then set all values of ON_HAND_VALUE to ON_HAND PRICE 9. In the NONAPPLIANCE table, increase the length of the DESCRIPTION column to 30 characters. 10. Remove the NONAPPLIANCE table from the Premiere Products database