Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please, can someone correct the error messages?? ie send CTRL-ALT-DEL + Disconnect Auto hide SQL Worksheet History 0.026 ID, (DI ID) AS OF ),2) AS

image text in transcribed Please, can someone correct the error messages??
ie send CTRL-ALT-DEL + Disconnect Auto hide SQL Worksheet History 0.026 ID, (DI ID) AS OF ),2) AS ROUND (SUM (PROFIT),2) AS TOTAL PROF FROM ORDER ITEMS OI, ORDERS O WHERE OI.ORDER ID 0.ORDER ID GROUP BY ROLLUP ID) ORDER BY OMBER OF ORDERS: Saipt Output x Error starting at line : 22 in command - SELECT CUSTOMER ID, COONT (DSTINCT .ORDER ID) AS "KMBER OF ORDERS.. ROOND ( ROUND (SUM (PROFIT),2) AS TOTAL PROFIT FROM ORDER ITEMS o1, ORDERS O WHERE OZ ORDER ID -O.ORDER TD GROUP BY ROLLUP (CUSTOMER ID) ORDER BY NUMBER OF ORDERS" Error at Cormand Line : 23 Column : e Error report - SQL. Error: ORA-00923: FROM keyword not found where expected 00923. o0000FROM keyword not found wheze expected *Cause: Action

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Application Development And Administration

Authors: Michael V. Mannino

4th Edition

0615231047, 978-0615231044

More Books

Students also viewed these Databases questions

Question

Why is there a need for audit in the public sector?

Answered: 1 week ago