Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

solve the following SQL queries, write the code on the first space and add a screenshot of the result on the second. Customers table

solve the following SQL queries, write the code on the first space and add a screenshot of the result on the second.
Customers
\table[[customer_id,first_name,last_name,age,country],[1,John,Doe,31,USA],[2,Robert,Luna,22,USA],[3,David,Robinson,22,UK],[4,John,Reinhardt,25,UK],[5,Betty,Doe,28,UAE]]
Orders
\table[[order_id,item,amount,customer_id],[1,Keyboard,400,4],[2,Mouse,300,4],[3,Monitor,12000,3],[4,Keyboard,400,1],[5,Mousepad,250,2]]
Shippings
\table[[shipping_id,status,customer],[1,Pending,2],[2,Pending,4],[3,Delivered,3],[4,Pending,5],[5,Delivered,1]]
1
Find the maximum ordered itemm.
Capture SQL code and result.
image text in transcribed

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_2

Step: 3

blur-text-image_3

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

OCA Oracle Database SQL Exam Guide Exam 1Z0-071

Authors: Steve O'Hearn

1st Edition

1259585492, 978-1259585494

More Books

Students also viewed these Databases questions