Questions：a) From table Vendor, list the Vend_ID, Vend_Name, Vend_Contact of all vendorswhose 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 citywhere the number of vendors is greater than 2. Use the alias TotalVendors for thenumber 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 wheretahe ord_tot_cost more than $8000 and less than $15000.