Sql query for a view. Use product_information, inventories, locations and warehouses tables. In the view show warehouse id, the total number of products currently available from this warehouse, and the list of the products that are available for sale from that warehouse (separated by a comma). Label the columns in the view as: warehouse_id, Num_products and List_of_products.