Help me with this SQL homework on Azure studios Please.

Oracle 12c: SQL
3rd Edition
ISBN:9781305251038
Author:Joan Casteel
Publisher:Joan Casteel
Chapter6: Additional Database Objects
Section: Chapter Questions
Problem 6HOA: A new table has been requested to support tracking automated emails sent to customers. Create the...
icon
Related questions
Question

Help me with this SQL homework on Azure studios Please. 

Question 3
Use the Sales. Customer table
Using the concat function, create the location alias (rename) from Customer Country, CustomerRegion and CustomerCity.
Make sure that there is a comma space seperation such as Canada, BC, Tsawassen
Make sure the result set has only 91 rows
Customer CompanyName
Customer NRZBB
Customer MLTDN
Customer KBUDE
Customer HFBZG
Customer HGVLZ
Customer XHXJV
Customer QXVLA
Customer QUHWH
Customer RTXGC
Customer EEALV
CustomerContactName
Allen, Michael
Hassall, Mark
Strome, David
Cunningham, Conor
Higginbotham, Tom
Poland, Carole
Bansal, Dushyant
Ilyina, Julia
Raghav, Amritansh
Culp, Scott
CustomerCity CustomerRegion CustomerCountry
NULL
Germany
NULL
Mexico
NULL
Mexico
NULL
UK
NULL
Sweden
NULL
Germany
NULL
France
NULL
NULL
BC
Berlin
Mexico D.F.
Mexico D.F.
London
Lule
Mannheim
Strasbourg
Madrid
Marseille
Tsawassen
Spain
France
Canada
Location
Germany, Berlin
Mexico, Mexico D.F.
Mexico, Mexico D.F.
UK, London
Sweden, Lulet
Germany, Mannheim
France, Strasbourg
Spain, Madrid
France, Marseille
Canada, BC, Tsawassen
Transcribed Image Text:Question 3 Use the Sales. Customer table Using the concat function, create the location alias (rename) from Customer Country, CustomerRegion and CustomerCity. Make sure that there is a comma space seperation such as Canada, BC, Tsawassen Make sure the result set has only 91 rows Customer CompanyName Customer NRZBB Customer MLTDN Customer KBUDE Customer HFBZG Customer HGVLZ Customer XHXJV Customer QXVLA Customer QUHWH Customer RTXGC Customer EEALV CustomerContactName Allen, Michael Hassall, Mark Strome, David Cunningham, Conor Higginbotham, Tom Poland, Carole Bansal, Dushyant Ilyina, Julia Raghav, Amritansh Culp, Scott CustomerCity CustomerRegion CustomerCountry NULL Germany NULL Mexico NULL Mexico NULL UK NULL Sweden NULL Germany NULL France NULL NULL BC Berlin Mexico D.F. Mexico D.F. London Lule Mannheim Strasbourg Madrid Marseille Tsawassen Spain France Canada Location Germany, Berlin Mexico, Mexico D.F. Mexico, Mexico D.F. UK, London Sweden, Lulet Germany, Mannheim France, Strasbourg Spain, Madrid France, Marseille Canada, BC, Tsawassen
>
dbo.Digits
dbo.Nums
HR.Employee
HR.EmployeePay...
Human Resources.Employee
Person. Person
Production.Category
Production.Product
Production. Supplier
Relational Calculii.USSupre...
Relational CrossJoin.S1
Relational CrossJoin.S2
Sales.Customer
Sales.Order
Sales.OrderDetail
Sales.Shipper
SQLChallenge.logs
SystemVersioned.Employe...
Triggered.Audit Triggered E...
Triggered. Employee
Transcribed Image Text:> dbo.Digits dbo.Nums HR.Employee HR.EmployeePay... Human Resources.Employee Person. Person Production.Category Production.Product Production. Supplier Relational Calculii.USSupre... Relational CrossJoin.S1 Relational CrossJoin.S2 Sales.Customer Sales.Order Sales.OrderDetail Sales.Shipper SQLChallenge.logs SystemVersioned.Employe... Triggered.Audit Triggered E... Triggered. Employee
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Single Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
CMPTR
CMPTR
Computer Science
ISBN:
9781337681872
Author:
PINARD
Publisher:
Cengage