全部博文（239）
发布时间：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.........【阅读全文】
发布时间：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 .........【阅读全文】
发布时间：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.........【阅读全文】
发布时间：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.........【阅读全文】
发布时间：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.........【阅读全文】
