Get reliable answers to your questions at Westonci.ca, where our knowledgeable community is always ready to help. Experience the convenience of finding accurate answers to your questions from knowledgeable experts on our platform. Our platform offers a seamless experience for finding reliable answers from a network of knowledgeable professionals.

By Using the following schema, answer the following SQL queries and commands: Product(P_code.P_name, P_price, P_on_hand,vend_code) Vender(vend_code, vend_fname, vend_areacode, vend_phone) 1- find the venders names who sell products in TN-5 area and their names include "dan". 2- find the code, name and vender code of product that has price between 1500S and 2500S and the product that has price between 48005 and 5600S. 3- Find the name, and code of venders who had 5 microwaves that has price less than 3500S. 4- Find the phone numbers of venders who sell Televisions. 5- Delete the records of venders who their first name is 'smith'