FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write a SQL to identify customers (CUSTOMER_ID) who placed more than 3 orders in year 2014 and 2015 each. If a customer placed more than

Write a SQL to identify customers (CUSTOMER_ID) who placed more than 3 orders in year 2014 and 2015 each. If a customer placed more than 3 orders in year 2014 but did NOT place more than 3 orders in 2015, that customer should not be included in the output.

Table Name: CUST_ORDERS

ORDER_ID

CUSTOMER_ID

ORDER_DATE

101

201

2014-01-01

102

202

2014-02-12

103

203

2014-03-05

104

204

2014-04-15

105

202

2014-05-15

106

202

2014-07-10

107

203

2014-09-15

108

202

2014-12-15

109

201

2015-01-01

110

202

2015-02-12

111

202

2015-03-05

112

201

2015-04-15

113

202

2015-05-15

114

202

2015-07-10

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

3. Many parents blame children for encopresis. To what extent is encopresis volitional? How might blaming or punishing children exacerbate the problem?

Answered: 1 week ago

Question

★★★★★
In Russia, Procter & Gamble markets Tide, its U.S. premium laundry detergent brand, as an economy brand with the slogan Tide is a guarantee of clean clothes. Except for the brand name and the product...

Answered: 1 week ago

Question

★★★★★
Multiple Choice Question 127 a product requiring 8 pounds of material at $1.50 per pound. Oriole produced 11200 units of this product during 2016 resulting in a $39000 unfavorable materials quantity...

Answered: 1 week ago

Question

★★★★★
20. Financial Accounting is done for each department. True False 20. Financial Accounting is done for each department. True False

Answered: 1 week ago

Question

★★★★★
What is the overhead application rate per direct labor hour? * (1 Point) BREAD Co. uses a job order costing system. At the beginning of January, the company had 2 jobs in process with the following...

Answered: 1 week ago

Question

★★★★★
Feedback Print A 5 nC charge is located at the origin. What are the electric fields at the positions A = (10 cm, 0 cm), B = (-10 cm, 10 cm), and C = (-10 cm, -10 cm)? Write each electric field vector...

Answered: 1 week ago

Question

★★★★★
A History Achievement Test out of 80 points is administered to a Grade 10 class of 30 students. Their scores are randomly listed below. 78 46 61 49 58 61 64 58 55 80 40 52 78 55 63 55 49 59 64 58 53...

Answered: 1 week ago

Question

★★★★★
Compute the Adjusted R-Squared value for Model 1. Discuss why Adjusted R-squared and the R-squared values are different. Model 1 Let's consider the following R output for a regression model which we...

Answered: 1 week ago

Question

★★★★★
You are the IT administrator for a small corporate network. The company has a single Active Directory domain named CorpNet.local. You need to increase the domain's authentication security. You need...

Answered: 1 week ago

Previous Question Next Question