Hi,
I want to fetch the orders placed through the public domain email address, my order table "aux_order" table. Please let me know what the public domain email address that should be considered and how we need to frame the SQL to get the order details for these public email address in one query?
select * from aux_order where email like lower ('%@gmail.com%') -- like wise for other public email address
Thanks.