SQL help
$5-10 USD
Thanh toán khi bàn giao
I need to manipulate the following database tables using Oracle’s SQL*Plus.
The objective is to create a table called balance that includes the customer ID, last name, first name, and the customer’s total balance (the sum of price for all orders). Study the tables below: customer and order
CUSTOMER
CUSTOMER_ID LAST FIRST STREET CITY STATE ZIP
----------- ------- ------- --------- ------- ----- ------
124 Martin Dan 418 Pine Grant MI 49219
1552 Adams Joan 3435 Elm Harper TN 39805
... ... ... ... ... ... ...
ORDER
ORDER_NUM CUSTOMER_ID ORDER_DATE PRICE
--------- ----------- ---------- -------
10024 5642 12/8/1999 501.89
10025 124 30/9/1999 215.95
10026 4542 11/1/2000 570.25
10027 124 12/2/2000 420.60
... ... ... ...
The result should be a table that looks like this:
BALANCE
CUSTOMER_ID LAST FIRST TOTAL_BALANCE
----------- ------- ------- -------------
1552 Adams Joan 845.56
5642 Collins Chip 760.01
4542 Ira Sally 570.25
... ... ... ...
Unfortunately, there are several mistakes. I need the mistakes pointed out in a word document. By First examining the following text in the SQL*Plus window:
The following SQL commands have errors and are not yielding the correct result. I need the attached code modified to get the desired table above.
## Deliverables
I need the mistakes pointed out in a word document, I would also appreciate if you could in a few paragraphs compare Oracle to MS Access and SQL Server. Just highlight the differences and so forth.
## Platform
The assignment can be done in Word or Office.
ID dự án: #3081989