How to identify septic shock patients in mimic iv 2.2 database using sql code.

Prerequisites

• Put an X between the brackets on this line if you have done all of the following:
  • Checked the online documentation: https://mimic.mit.edu/
  • Checked that your issue isn't already addressed: https://github.com/MIT-LCP/mimic-code/issues?utf8=%E2%9C%93&q=

Description

Hello, Recently, I have been trying to extract patients with septic shock in the ICU and have encountered some difficulties.
Previously, I saw an discussion on how to identify septic shock patients, and I was greatly inspired by it. However, I do not quite understand how the third standard is expressed in SQL code in mimic iv 2.2 database.
"3.Patients with septic shock can be identified with a clinical construct of sepsis with persisting hypotension requiring
vasopressors to maintain MAP ≥65 mm Hg and having a serum lactate level >2 mmol/L(18 mg/dL) despite adequate volume resuscitation."
May I ask if you can share similar SQL code examples for my reference？Thank you very much！
similar issues: Onset time of septic shock #576

Start with the MIMIC documentation and the related issue, Onset time of septic shock #576, to understand the existing septic-shock definition and MIMIC-IV 2.2 data structures. Determine whether the requested SQL example belongs in an existing query or documentation location; done means providing a reviewed, reproducible example that addresses the third criterion and is consistent with the documented data.