Task 21: List the item ID, description, and category of all items that are in the DOG or CAT category and contain the word Small in the description. Expected Results ITEM_ID    DESCRIPTION    CATEGORY LD14    Locking Small Dog Door    DOG SP91    Small Pet Carrier    CAT This is the solution I have been trying that is not working: SELECT ITEM_ID, DESCRIPTION, CATEGORY FROM ITEM WHERE CATEGORY AND('CAT', 'DOG') AND DESCRIPTION LIKE '%SMALL%';

For this portion of the lab design the solution in the following manner: Create a table using a two-dimensional list that stores a Fahrenheit temperature and the equivalent Celsius temperature. Use the following range of Fahrenheit temperatures:Starting at -10 through 100 in increments of 10. Thus, the Fahrenheit temperatures will be:-10, 0, 10, 20, 30, 40, 50…and so on.Display the contents of the list.Similarly create tables/lists for the following, starting at 0 through 100 in increments of 10:Miles to kilometersGallons to litersPounds to kilogramsInches to centimetersDisplay the contents of each listSave the program as firstname_lastname_Lab7a.py where you will replace firstname and lastname with your actual first and last name.

Task 12: When deleting a customer, subtract the balance multiplied by the sales rep’s commission rate from the commission for the corresponding sales rep.

Task 22: KimTay Pet Supplies is considering discounting the price of all items by 10 percent. List the item ID, description, price, and discounted price for all items. Use DISCOUNTED_PRICE as the name for the computed column.