PepperPart3

Submit the SQL statements that answer the following (try them out in APEX, then copy and paste the SELECT statement into a word file, turn word file into Engrade under Pepper Part 3)


 * 1) Display the name of peppers with an shu less than 1,500. Why isn't Rotilla in the list?
 * 2) Display the SHU of the extracts?
 * 3) All the peppers that are 5000 SHUs
 * 4) All the peppers not 40000 SHUs
 * 5) Which peppers (not includeing extracts) are stronger than the Habanero?
 * 6) Which peppers are bigger than Tabiche or smaller than Manzano
 * 7) Which peppers fall between Bahamian and Jalapeno on the SHU scale