Chinaunix首页 | 论坛 | 博客
  • 博客访问: 940435
  • 博文数量: 239
  • 博客积分: 10
  • 博客等级: 民兵
  • 技术积分: 3618
  • 用 户 组: 普通用户
  • 注册时间: 2012-11-12 13:17








发布时间:2015-06-20 19:37:25

15. View the Exhibit and examine the data in the CUSTOMERS table.  Evaluate the following query: SQL>  SELECT  cust_name  AS  "NAME",  cust_credit_limit/2  AS  MIDPOINT,MIDPOINT+100  AS  "MAX LOWER LIMIT" FROM customers; The above query produc.........【阅读全文】

阅读(812) | 评论(0) | 转发(0)

发布时间:2015-06-20 14:29:45

14.  Using  the  CUSTOMERS  table,   you  need  to  generate  a  report  that  shows  50%  of  each   credit amount in each income level. The report should NOT show any repeated credit amounts in each income .........【阅读全文】

阅读(779) | 评论(0) | 转发(0)

发布时间:2015-03-20 01:57:06

13. View the Exhibit and examine the structure of the PRODUCTS table. You need to generate a report in the following format: CATEGORIES 5MP Digital Photo Camera's category is Photo Y Box's category is Electronics Envoy Ambassador's category is Hardware Which two queries would give the required.........【阅读全文】

阅读(884) | 评论(0) | 转发(0)

发布时间:2015-03-20 01:43:05

12. You need to produce a report where each customer's credit limit has been incremented by $1000. In the output,  t he customer's  last name should have the heading Name and the   incremented credit  limit should be labeled New Credit Limit. The column headings should hav.........【阅读全文】

阅读(739) | 评论(0) | 转发(0)

发布时间:2015-03-20 01:25:41

11. View the Exhibit and examine the structure of the PRODUCTS table. All products have a list price. You issue the following command to display the total price of each product after a discount of 25% and atax of 15% are   applied on it. Freight charges of $100 have to be applied to all.........【阅读全文】

阅读(840) | 评论(0) | 转发(0)

登录 注册