Questions： a) From table Vendor, list the Vend_ID, Vend_Name, Vend_Contact of all vendors
whose name begins with ‘P’. List them in descending order of Vend_City.
b) From table Vendor, list the vendor city and the number of vendors in each city
where the number of vendors is greater than 2. Use the alias TotalVendors for the
number of vendors.
c) From table Item, display the total number of items whose item status is "1" or "2".
Name this total NumberOfItems. Note that item status is a text field.
d) From table order, display the order_id, ord_date, ord_status of all the orders where
tahe ord_tot_cost more than $8000 and less than $15000.