Class Sixteen: Text(CASE STATEMENT )

EXAMPLE

1). SELECT [City Key],Description,[Unit Price],

 CASE

       WHEN [Unit Price] > 200 THEN ‘GOOD’

               WHEN [Unit Price] Between 18 and 35 THEN ‘FAIR’

               ELSE ‘POOR’

               END AS Remark

 FROM [Fact].[Sale]

 WHERE [Unit Price] IS NOT NULL

2). SELECT [City Key], Description,[Unit Price],Quantity, Profit,

 CASE

      WHEN Profit >= 800 THEN ‘Better sales’

              WHEN Profit >=500 THEN ‘Good sales’

              ELSE ‘Fair sales’

              END AS Remark

 FROM [Fact].[Sale]

 JOIN [Dimension].[Customer]

 ON [Dimension].[Customer].[Customer Key]=[Fact].[Sale].[Customer Key]

3). SELECT [City Key], Description,[Unit Price],Quantity, Profit,

 CASE

      WHEN Profit >= 800 THEN Profit + (Profit +.10)

              WHEN Profit >=500 THEN Profit +(Profit +.5)

              ELSE Profit +(Profit +.2)

              END

 FROM [Fact].[Sale]

 JOIN [Dimension].[Customer]

 ON [Dimension].[Customer].[Customer Key]=[Fact].[Sale].[Customer Key]