Database: e_commerce
Question: What are the ids , names , prices , and colors of all products that have been listed in less than two orders ?
SQL:
select t1.product_id ,  t1.product_name ,  t1.product_price ,  t1.product_color from products as t1 join order_items as t2 on t1.product_id  =  t2.product_id join orders as t3 on t2.order_id  =  t3.order_id group by t1.product_id having count(*) < 2