Question: ORACLE SQL question QUESTION 3 Remember --- need both the SQL and the output to get any marks. MUST USE the ON style of JOIN

ORACLE SQL question

the output to get any marks. MUST USE the ON style of

JOIN For any customers with customer names that include Go Outlet provide

(1) customer number, (2) customer name and (3) order number (4) product

QUESTION 3 Remember --- need both the SQL and the output to get any marks. MUST USE the ON style of JOIN For any customers with customer names that include Go Outlet provide (1) customer number, (2) customer name and (3) order number (4) product number but only if they ordered any of these products -- 40301, 40303, 40300, 40310, 40306. Put result in order number order. Tables (Filtered) COUNTRIES CNAME 1 CUST_NO 0 STATUS 1 CUST_TYPE 0 COUNTRY_CD ADDRESS1 I BRANCH_CD ADDRESS2 PROV_STATE DO CUSTOMERS POST_ZIP PHONE_NO CITY FAX_NO SALES_REP 1 CONTACT DEPARTMENTS EMPLOYEES 69 JOB_GRADES 0 JOB_HISTORY AD LOCATIONS - - # e- ................. ...................................... ...................... Connections Emma Workshet GS IQTY - DISC_PERC ORDERS ORDER_NO REP_NO CUST_NO ORDER_DT I STATUS CHANNEL 0 PRODUCTS PROD_NO - PROD_LINE PROD_TYPE PROD_NAME I PROD COST PRODSELL I STATUS II PICTURE I SALES_2016 SALES_2015 II SALES_2014 II SALES_2013 SID - SUPPLIERS 13 Views Reports Script E LUCIDE. Idule UBS301_201B23.CUSTOMERS@mmaahi emmaahi CUSTOMERS Columns Data Model Constraints Grants Statistics Triggers Flashback | Dependencies | Details Partitions Indexes SQL EX Sort.. Filter: CUST_NO CNAME STATUS CUST_TYPE COUNTRY_CD BRANCH CD ADDRESS1 1146 Florida Sun Sports 4 Sports Chain US M IA 43236 Robin 1147 Juan's Sports 1 Sports Chain MX MEX 43235 Calle 1148 Juan's Shorts 2 Sports Chain MX MEXER 132364 Av Pa 1149 GO Outlet Denver GO Outlet US DEN 6 3231 Cathca 1150 GO Outlet Dallas GO Outlet US 232375 Sparks 1001 Go Outlet Montreal Go Outlet CA 53230 Place 1002 Ultra Sports 5 Mass Marketer US 4323770 Duke 1003 Vacation Central 5 Mass Marketer CA 1323166 Alber 1004 Mountain Madness 5 A Mass Marketer US SFR 43235 Statesi 1005 GO Outlet Boston A GO Outlet US BOS 432353 Old Cr 1006 Bergsteiger G.m.b.H. Independent DE FRNK L323yoner Str 1007 Backwoods Equipment (Rom) A Independent AU ROM 132320 Pacifi 1008 Botanechi K.K. Independent JP TOKY 6323F Green L 1009 GO Outlet Kista AB GO Outlet SE STOC V323illagatan 1010 Andes Camping Supplies 6 Camping Chain CA 132311 West La 1011 GO Outlet Singapore GO Outlet SG SING 732350-0 Chai 1012 Act 'N'Up Fitness 5- Mass Marketer US 532355 Mt. Lir 1013 New Wave Wilderness 6 Camping Chain CA TOR 432331 Yonge 1014 Wally Mart 5 Mass Marketer US 632375 East 52 Camping Chain US SFR 1015 Desert Duds and Tees 8 632372 Parkvie Mass Marketer SE STOC 1016 Over the Top Cycles 4 1323safjordsga 1017 Rock Steady Independent US 432364 Clear W 1018 Clear Valley Waters 5 Mass Marketer US 132361 Industr VAN NY NY DEN SEA

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

ORACLE SQL Question Use Oracle-VM SQL Data Definition Language to create the following Bank-and-Customer database. You should properly define primary keys and foreign keys and then use SQL Query...

ORACLE SQL Question 2 Use Oracle-VM SQL Data Definition Language to create the following Bank-and-Customer database. You should properly define primary keys and foreign keys and then use SQL Query...

Case assignments must be completed with a written 1-page study on the assigned case questions in the textbook. The format requested for these assignments is based on elaborating and including two...

Mr. Om was very pleased with the work you did for him last week and wants you to retrieve a few more reports for him. He has also recommended you to work for his friend, Mr. Bok who owns a small...

SIT103 Data and Information Management T2, 2023 Summative assessment task-2: A real-world database design and implementation project Due dates: Part-1: Project proposal, due date: Wednesday 10th May...

Help on creating a procedure in sql, this file will be used to compile. Then afterwards I have to make another sql file to run and output the results. But for this part I'm stuck on the procedure...

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

Hello I need A-V all Query Design SQL form Queen Case Study chapter -3 thank you SQL Server, Oracle Database, and MySQL are available on our Web site at www.pearsonhighered.com/kroenke. If you are...

Hi need to get done only one article from the given ones but please choose any one except article no 2 as i have already done that one. please choose right theory and apply it on the article and...

Background on SQL Server: Microsoft SQL Server is a popular enterprise-class DBMS that has been around for many years. SQL Server really handles SQL well, better than simpler tools such as Microsoft...

Write a memo for the tax research file on the difference between "inbound" and "outbound" activities in the context of U.S. taxation of international income.

Moose Stores has outstanding one million shares of common stock with a total market value of $40 million. It now announces an issue of one million warrants at $5 each. Each warrant entitles the owner...

C mo se conoci el gabinete NO oficial de Andrew Jackson?

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Are there any questions that you want to ask?

2. A good source for seeing the subtle differences between legal and illegal job interview questions is at this job Web site: www.jobweb.com/Interview/help .aspx?id=1343&terms=illegal+questions. Use...

C Do you consider the material you post on various Web sites private? Do you think its ethical for employers to be looking at your postings?