Question: Problem 1 Show all customers and display whether they placed an order in the first week of December 2017 select c.CustomerID, c.CustFirstName + ' '

Problem 1 Show all customers and display whether they placed an order in the first week of December 2017

select c.CustomerID, c.CustFirstName + ' ' + c.CustLastName as CustomerName,

iif(CustomerID in (

select o.CustomerID from orders as o

where o.OrderDate>= '2017-12-01'

and o.OrderDate<='2017-12-07' ),

'Customer ordered','Customer did not order')

as Order_Status

from customers as c

How to use this in CASE Query instead of IIF

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To rewrite the SQL query using a CASE statement instead of IIF you can replace ... View full answer

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!

Q:

-- ************************************************************* -- This script creates the database -- for Labs 4-7 based on OM (Order Management) database -- **REVISED by PRP to remove some orders...

Q:

CIS-336: Lab7: Working with Views LAB OVERVIEW Lab 7 will introduce the concept of database views. This lab may be completed using either DeVrys Omnymbus EDUPE-APP lab environment, or a local copy of...

Q:

Select yes or no a. Whether and how fast to boost production capabilities for the Model 3. (Click to select) Yes No b. How much to spend currently on R&D for the Tesla Semi and the Model Y? Does the...

Q:

After Reading the Case. Clearly answer the following questions in a single post. 1) In your opinion , How did ChassisCo contribute to the cause of crisis at Athens in 2004? How did Toyota contribute...

Q:

IOE 419 Mark S. Daskin Service Operations Management IOE Department Winter, 2017 University of Michigan Problem set 4 DUE: MONDAY - February 20, 2017 Points: 100 points total Problem 1: Babette has...

Q:

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

Q:

EARNINGS MANAGEMENT AND FRAUD PROJECT ACCT 312: Spring 2020 You have just been hired as the controller for Wholesale Corp. The last controller left suddenly. The day after you started work, the...

Q:

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...

Q:

1) What is the project in Tunica and what management was expected to achieve? 2) Who were the stakeholders in Tunica? 3) What were they expected to achieve at Kaizen events in terms of implementing...

Q:

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

Q:

Implementing an ABC system should proceed only if management believes the benefits of doing so will exceed the costs. The costs of an ABC system are not difficult to quantify. They include...

Q:

Complete the payroll for the month in the table below. The East Indies Corporation has four employees. The following is the payroll spreadsheet. Sue INCOME Basic Pay Overtime Travelling Uniform...

Q:

and for color, where " B " is brown and " b " is white. If a mall, whice mule goat maies widh a large, brown lemale goar of an unloown genotype, that is the probability that they would produce imall,...

Q:

Given the following relational database schema: Student = (SSN, Name, Major) Course = ( CourseNumber, PrerequisiteCourseNumber, Course Title, NumberUnits) Section = ( CourseNumber, Quarter,...