(Solved) : Create Sql Select Statement Using Basic Cte S Worldwideimportersdw Database Query Needs Fo Q29649180 . . . .

Create a SQL SELECT statement using a basic CTE(s) on theWorldWideImportersDW database.

Your query needs to have the following:

Easy to read

Could be a useful report/data feed

Contains an INNER JOIN, GROUP BY and an aggregate function

ALSO Find a case for and write a query with a recursive CTE forone of your databases.

BELOW IS THE TABLES/COLUMNS FROM WIDEWORLDIMPORTERSDW. PLEASEREFER TO THOSE WHILE ANSWERING

1.dimension.city                                              

City

City Key

Continent

Country

Latest Recorded Population

Lineage Key

Location

Region

Sales Territory

State Province

Subregion

Valid From

Valid To

WWI City ID

2. dimension.customer

Bill To Customer

Buying Group

Category

Customer

Customer Key

Lineage Key

Postal Code

Primary Contact

Valid From

Valid To

WWI Customer ID

3. dimension.date

Calendar Month Label

Calendar Month Number

Calendar Year

Calendar Year Label

Date

Day

Day Number

Fiscal Month Label

Fiscal Month Number

4.dimension.employee

Employee

Employee Key

Is Salesperson

Lineage Key

Photo

Preferred Name

Valid From

Valid