select order_num from OrderItems group by order_num having sum(quantity)>=100 order by order_num;

select vend_id,min(prod_price) cheapest_item from Products group by vend_id order by cheapest_item;

select order_num,count(order_num) order_lines from OrderItems group by order_num order by order_lines;

select max(prod_price) max_price from Products where prod_price<=10;

select sum(quantity) items_ordered from OrderItems where prod_id='BR01';

这道题用到三个函数：concat()用于拼接字符串upper()把字符串转为大写substring()用于从指定位置开始截取指定长度的字符串三者结合就能得到题目要求的用户登陆名select cust_id,cust_name,concat(upper(substring(cust_name,1,2)),'',upper(substring(cust_city,1,3))) user_loginfrom Customers;

select prod_id,prod_price,prod_price*0.9 sale_price from Products ;

因为不确定carrots和toy的前后位置关系，所以分为两种情况，一种是carrots在前,一种是toy在前，这两种情况都符合，中间用or连接select * from Productswhere prod_desc like '%carrots%toy%' or prod_desc like '%toy%carrots%';

select * from Products where prod_desc not like '%toy%' order by prod_name;

select * from Products where prod_desc like '%toy%';

select prod_name,prod_price from Products where prod_price between 3 and 6 order by prod_price;

select order_num,prod_id,quantityfrom OrderItems where quantity>=100 and prod_id in('BR01','BR02','BR03');

select vend_namefrom Vendorswhere vend_country='USA' and vend_state='CA';

select distinct order_numfrom OrderItemswhere quantity>=100;