data-engineer video for an e-commerce company uses Amazon RDS for PostgreSQL to manage their product inventory. The database contains a table named products
An e-commerce company uses Amazon RDS for PostgreSQL to manage their product inventory. The database contains a table named products with columns id , name , price , and quantity_in_stock . The company needs to write an SQL query to find all products that have a price greater than $50 and a quantity in stock less than 100. Which SQL query should the company use to retrieve the correct data from the products table in their PostgreSQL database?