当前位置 博文首页 > 无限迭代中......:《数据库系统实训》实验报告——子查询与组合
题号: 1.1
SQL语句描述:select cust_id from orders where order_num in (SELECT ORDER_NUM FROM ORDERITEMS where prod_id='tnt2');
查询功能描述:查询购买ID为tnt2的产品的客户;
执行结果截图:
题号: 2.1
SQL语句描述:select vend_name,prod_name,prod_price
?? from vendors,products
?? where vendors.vend_id=products.vend_id
?? order by vend_name,prod_name;
查询功能描述:查询所有供应商名称及产品名称、价格,并且按供应商和产品名称排序;
执行结果截图:
题号: 3.1
SQL语句描述:select customers.cust_id,
customers.cust_name,
count(orders.order_num) as num_ord
from customers inner join orders
on customers.cust_id=orders.cust_id
group by customers.cust_id;
查询功能描述:查询所有顾客的订单数量;
执行结果截图:
题号: 4.1
SQL语句描述:select vend_id,prod_id,prod_price
from products
where prod_price<=5
union
select vend_id,prod_id,prod_price
from products
where vend_id in(1001,1002);
查询功能描述:查询供应商ID为1001,1002和价格小于等于5的供应商ID及产品名称、价格;
执行结果截图:
题号: 5.1
SQL语句描述:select note_text from productnotes where match(note_text) against('rabbit');
查询功能描述:查询含有rabbit的文本内容;
执行结果截图:
cs