Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3. Consider the following two tables CUSTOMERS and ORDERS: ORDERS [Primary Key OID] CUSTOMERS [Primary Key -ID] ID NAME AGE ADDRESS SALARY 01D Date ClD

image text in transcribed
3. Consider the following two tables CUSTOMERS and ORDERS: ORDERS [Primary Key OID] CUSTOMERS [Primary Key -ID] ID NAME AGE ADDRESS SALARY 01D Date ClD AMOUNT 1 Ramesh 32 Fondren 2000.00 102 11/01/17 3 2 Khilan 3 Kaushik 23 Gessener 2000.00 101 06/01/18 2 1560 4 Chaitali 25 Wirt 5 Hardik 6 Komal 7 Muffy 3000 25 Hilcroft1500.00 100 03/31/18 3 1500 6500.00 103 09/20/18 4 2060 27 Tirewest 8500.00 22 Gulfton4500.00 24 Travis 10000.00 3a) What will be the output of the following query? (20 points) SELECT ID, NAME, AMOUNT, DATE FROM CUSTOMERS a INNER JOIN ORDERS b WHERE a.ID b.CID; 3b) What will be the output of the following query? (20 points) SELECT ID, NAME, AMOUNT, DATE FROM CUSTOMERS a LEFT JOIN ORDERS b WHERE a.ID b.CID; 3c) What will be the output of the following query? (20 points) SELECT ID, NAME, AMOUNT, DATE FROM CUSTOMERS a RIGHT JOIN ORDERS b WHERE a.ID = b.ClD

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

Practical Oracle8I Building Efficient Databases

Authors: Jonathan Lewis

1st Edition

0201715848, 978-0201715842

More Books

Students also viewed these Databases questions