s SQL homework on Azure studios Plea

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

Help me with this SQL homework on Azure studios Please. 

Question 4
Use the previous question's query
create a predicate using the location to isolate Coutries that begin with G or F or A or I with a regex expression
Make sure the result set has only 33 rows and order by Customer Country
Customer CompanyName
Customer NRZBB
Customer RTXGC
Customer PSNMQ
Customer THHDP
Customer WMFEA
Customer FRXZL
CustomerContactName
Allen, Michael
Raghav, Amritansh
Ray, Mike
Kane, John
Schmollerl, Martin
@skarsson, Jon Harry
CustomerCity
Berlin
Marseille
Buenos Aires
Graz
Torino
Cork
CustomerRegion
NULL
NULL
NULL
NULL
NULL
Co. Cork
CustomerCountry Location
Germany
France
Argentina
Austria
Italy
Ireland
Germany, Berlin
France, Marseille
Argentina, Buenos Aires
Austria, Graz
Italy, Torino
Ireland, Co. Cork, Cork
Transcribed Image Text:Question 4 Use the previous question's query create a predicate using the location to isolate Coutries that begin with G or F or A or I with a regex expression Make sure the result set has only 33 rows and order by Customer Country Customer CompanyName Customer NRZBB Customer RTXGC Customer PSNMQ Customer THHDP Customer WMFEA Customer FRXZL CustomerContactName Allen, Michael Raghav, Amritansh Ray, Mike Kane, John Schmollerl, Martin @skarsson, Jon Harry CustomerCity Berlin Marseille Buenos Aires Graz Torino Cork CustomerRegion NULL NULL NULL NULL NULL Co. Cork CustomerCountry Location Germany France Argentina Austria Italy Ireland Germany, Berlin France, Marseille Argentina, Buenos Aires Austria, Graz Italy, Torino Ireland, Co. Cork, Cork
>
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
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY