Create a query (pseudo code) based on the E-R diagram that can be used to generate it

Hospital Procedure PURCHASE PK Purchase_ID Product Quantity Total Enacts OPERATION PK Operation ID FK Surgeon_ID Quantity Price PATIENTS PK Patient_ID FK Hospital_ID undergoes HOSPITAL PK Hospital ID Name Address Stays in Phone Uses Maintains INVENTORY PK Product ID FK Manufacturer_ID Purchase Price Purchase_Date Catagory Location HOSPITAL BED PK Hospital Bed ID FK Patient ID EK Operation ID FK Hospital_ID Admission Time MANUFACTURER PK Manufacturer_ID FK Product ID Name Country Phone COMPONENT PK Product_ID System (Y/N) Product Description Price Discount (Y/N) Product Category Has/Addech -Creates- Is Billed 0 Mandatory, And- BILLING PK Billing_ID FK Purchase_ID Patient ACCT Total ACCESSORIES LEADS Lead Voltage_Type Lead_Voltage_Type Accessories Description Accessories_Description PACEMAKER SYSTEM Pacemaker Voltage Type Pacemaker_Voltage_Type