How could one show only customers who have ordered in the last year using sysdate - 365?
Fantastic news! We've Found the answer you've been seeking!
Question:
How could one show only customers who have ordered in the last year using sysdate - 365? Also, how does one show customers whose order haven't been cancelled in ORDER_STATUS?
Transcribed Image Text:
8.8 CUSTOMERS ✔CUSTOMER_ID 789 ✔FULL NAME A ✔ EMAIL ADDRESS A Conditions SQL W F Column CUSTOMER_ID FULL_NAME EMAIL_ADDRESS STORE_ID X Results ORDER_DATETIME STORE_NAME ORDERS -X ORDER_ID ✔ ORDER_DATETIME CUSTOMER_ID 789 ORDER_STATUS A 789 STORE_ID Saved SQL Alias CUSTOMER_ID FULL NAME EMAIL_ADDRESS STORE_ID ORDER DATETIME 789 STORE_NAME ✔STORE_ID ✔STORE_NAME ORDERS STORES STORES 789 A WEB_ADDRESS A PHYSICAL_ADDRESS A 789 789 STORES LATITUDE LONGITUDE LOGO Object CUSTOMERS CUSTOMERS CUSTOMERS LOGO MIMC TVDC A -X Condition Sort Type Asc Asc ✓ Asc ✓ Asc Asc ✓ Asc ✓ Sort Order Show ✓ > > > > > ✔ Function V > V < Group By Delete 0000 00 X X X X X X Cancel Run Return 8.8 CUSTOMERS ✔CUSTOMER_ID 789 ✔FULL NAME A ✔ EMAIL ADDRESS A Conditions SQL W F Column CUSTOMER_ID FULL_NAME EMAIL_ADDRESS STORE_ID X Results ORDER_DATETIME STORE_NAME ORDERS -X ORDER_ID ✔ ORDER_DATETIME CUSTOMER_ID 789 ORDER_STATUS A 789 STORE_ID Saved SQL Alias CUSTOMER_ID FULL NAME EMAIL_ADDRESS STORE_ID ORDER DATETIME 789 STORE_NAME ✔STORE_ID ✔STORE_NAME ORDERS STORES STORES 789 A WEB_ADDRESS A PHYSICAL_ADDRESS A 789 789 STORES LATITUDE LONGITUDE LOGO Object CUSTOMERS CUSTOMERS CUSTOMERS LOGO MIMC TVDC A -X Condition Sort Type Asc Asc ✓ Asc ✓ Asc Asc ✓ Asc ✓ Sort Order Show ✓ > > > > > ✔ Function V > V < Group By Delete 0000 00 X X X X X X Cancel Run Return
Expert Answer:
Answer rating: 100% (QA)
To show only customers who have ordered in the last year using SYSDATE 365 and ensuring that their o... View the full answer
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date:
Students also viewed these databases questions
-
You want to have $ 8000 by the time you finish college in 3 years. How much money should you deposit each quarter for the next 3 years into an account paying 9% per year compounded quarterly so that...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The company wants to see the total sale amount per sales person (salesman) for all orders. Assume that some online orders do not have any sales person involved. Display the salesman full name and the...
-
When Steve Jobs first demonstrated "the pinch"-the two-finger gesture to zoom in and out on photos and Web pages on the iPhone, it just rocked the mobile phone industry-the whole digital world heard...
-
In a certain region of the inertial reference frame there is magnetic field with induction B rotating with angular velocity to. Find V x E in this region as a function of vectors to and B.
-
What role does eye contact play in delivering an effective presentation? Provide examples.
-
When might the information from numeric information systems such as HR metrics and workforce analytics not generate any return on investment?
-
The Byrd Company had the following transactions during 2007 and 2008: 1. On December 24, 2007 a computer was purchased on account from Computers International for $60,000. Terms of the sale were...
-
A stock just paid a dividend of D 0 = $1.50. The required rate of return is r s = 16.0%, and the constant growth rate is g = 4.0%. What is the current stock price?
-
The Beef-Up Ranch feeds cattle for Midwestern farmers and delivers them to processing plants in Topeka, Kansas, and Tulsa, Oklahoma. The ranch must determine the amounts of cattle feed to buy so that...
-
FBT Calculation Chris is a full-time salesman employed by King; a forklift rental company located in Western Sydney which specialises in the rental and maintenance of a large fleet of forklifts and...
-
An eastern U.S. financial services company found itself way behind schedule and over budget on an important strategic program. Both the budget and schedule baselines had begun slipping almost from...
-
Bristols Bicycles maintains inventory records under the perpetual inventory system. At 30 June 2019, the inventory balance determined by the system showed a value of $300 000. However, on conducting...
-
Use the data in Table 1.11 to determine the 1991 cost in 2008 dollars of mailing a first-class letter. Is this value higher or lower than the actual $0.42 cost of mailing a letter in 2008? Date...
-
Terrific Town Houses Ltd is a large company registered in South Australia for the purpose of constructing blocks of home units and town houses. The company conducts its activities in all states. The...
-
A television manufacturing company performs quality assurance tests of its products before shipping them to the market. If the company chooses a random sample of 15 sets for the test, and assuming...
-
pls answer A fireman of mass 80 kg slides down a pole. When he reaches the bottom, which is 5.2 m below his starting point, his speed is 4.1 m/s. How much did his thermal energy increase? OOJ 0 2.2...
-
The area of a rectangle is 30 cm 2 and its perimeter is 26 cm. Find the length and width of the rectangle.
-
What does the breakeven time (BET) metric for the product development process measure?
-
1. What is kaizen costing? 2. What are the two general methods of information gathering and sharing when undertaking a benchmarking exercise?
-
Planning and flexible budget variances Tang Company??s production performance report for April includes the information shown below. Prepare a flexible budget for the items shown and compute the...
-
(a) How many of male respondents in this study had some college degree? (b) How would you describe the largest group of respondents? (c) What could be stated about the differences between male and...
-
(a) What percentage of those not completing high school were females? (b) What percentage of those not completing high school were males? (c) What percentage of those completing high school were...
-
What percentage of the 9,449 survey respondents live in the Eastern part of the county?
Study smarter with the SolutionInn App