select * from customers_info order by case when city is not null then city else country end

select customer_id ,case when latest_place_order_date is not null then '1' when latest_place_order_date is null then '0' end if_placed_order from customers_info

select cust_name,cust_contact,cust_email from Customers where cust_state='MI' union select cust_name,cust_contact,cust_email from Customers where cust_state='IL' order by cust_name

select prod_name from Products union select cust_name from Customers order by prod_name

# select c.cust_name,sum(oi.item_price*oi.quantity) as total_price # from Customers c,OrderItems oi,Orders o # where c.cust_id=o.cust_id and oi.order_num=o.order_num # group by c.cust_name # having total_price>=1000 # order by total_price select c.cust_name, sum(oi.item_price*oi.quantity) as t...

select cust_name,Orders.order_num,quantity*item_price as OrderTotal from Orders left join Customers on Orders.cust_id=Customers.cust_id left join OrderItems on Orders.order_num=OrderItems.order_num order by cust_name,Orders.order_num

# select cust_name,order_num # from Customers,Orders # where Customers.cust_id=Orders.cust_id # order by cust_name select cust_name,order_num from Customers inner join Orders on Customers.cust_id=Orders.cust_id order by cust_name

select cust_id,sum(item_price*quantity) as total_ordered from Orders,OrderItems where Orders.order_num=OrderItems.order_num group by cust_id order by total_ordered desc

select cust_id,cust_name, upper(concat(substr(cust_name,1,2),substr(cust_city,1,3)) )as user_login from Customers

select prod_name,prod_desc from Products where prod_desc not like "%toy%" order by prod_name

select prod_name,prod_desc from Products where prod_desc like '%toy%'

select order_num,prod_id,quantity from OrderItems where prod_id="BR01"OR prod_id="BR02" OR prod_id="BR03" having quantity>=100

select order_num,prod_id,quantity from OrderItems where prod_id="BR01"OR prod_id="BR02" OR prod_id="BR03" having quantity>=100

select DISTINCT prod_id from OrderItems