I have a sql table with inventory and standard quantity data of items in the organization called ZMLY_TKN, in the following structure:
A key column of storage site code number called ZSIMUL,
A column of storage site description called ZSIMUL_T,
Division code number column responsible for the storage site called ZPIKUD,
A column of the description of the division responsible for the storage called ZPIKUD_T,
A column of catalog number (material) called 0MATERIAL,
A column of the description of the catalog number (material) called 0MATERIAL_T,
A column of the amount of inventory for that material in the storage site called SCUTR,
A column of the material standard for the storage site (the standard describes a required quantity for the inventory at the storage site) called TKN_TAN.

For this table, create the SQL to answer the next question: how many materials in devision "Bravo", is in amount that larger than the standard for this storage site? Group by storage site.  You should write your response with 1000 or more words.
user