Question: Can someone help me with this please in SQL Problem 53 LargeCo is planning a new promotion in Alabama (AL) and wants to know about

Can someone help me with this please in SQL

Problem 53

LargeCo is planning a new promotion in Alabama (AL) and wants to know about the largest purchases made by customers in that state. Write a query to display the customer code, customer first name, last name, full address, invoice date, and invoice total of the largest purchase made by each customer in Alabama. Be certain to include any customers in Alabama who have never made a purchase; their invoice dates should be NULL and the invoice totals should display as 0. Sort the results by customer last name and then first name (Partial result are shown in Figure P7.53).

CUST_CODE CUST_FNAME CUST_LNAME CUST_STREET CUST_CITY CUST_STATE CUST_ZIP INV_DATE Largest Invoice 903 ROBIN ADDISON 323 LORETTA PLACE Mobile AL 36693 2017-08-26 230.63 643 NINA ALLEN 680 RED TALON DRIVE Robertsdale AL 36574 2017-06-21 11.99 295 DORTHY AUSTIN 829 BIG BEND LOOP Diamond Shamrock AL 36614 2017-04-24 589.75 393 FOSTER BERNAL 1299 EAST 3RD AVENUE Birmingham AL 35280 NULL 0.00 853 GAYLORD BOLTON 1069 LUGENE LANE Montgomery AL 36131 2017-11-25 372.68 925 ALANA BOOKER 1874 I STREET Mccullough AL 36502 2017-12-12 208.85 1248 LISA BRADY 491 LOWLAND AVENUE Daphne AL 36577 2017-12-05 414.47 538 CHIQUITA CALDWELL 1501 BRIGGS COURT Normal AL 35762 2017-05-26 143.90 89 MONICA CANTRELL 697 ADAK CIRCLE Loachapoka AL 36865 2017-03-31 516.58 CUST_CODE CUST_FNAME CUST_LNAME CUST_STREET CUST_CITY CUST_STATE CUST_ZIP INV_DATE Largest Invoice 903 ROBIN ADDISON 323 LORETTA PLACE Mobile AL 36693 2017-08-26 230.63 643 NINA ALLEN 680 RED TALON DRIVE Robertsdale AL 36574 2017-06-21 11.99 295 DORTHY AUSTIN 829 BIG BEND LOOP Diamond Shamrock AL 36614 2017-04-24 589.75 393 FOSTER BERNAL 1299 EAST 3RD AVENUE Birmingham AL 35280 NULL 0.00 853 GAYLORD BOLTON 1069 LUGENE LANE Montgomery AL 36131 2017-11-25 372.68 925 ALANA BOOKER 1874 I STREET Mccullough AL 36502 2017-12-12 208.85 1248 LISA BRADY 491 LOWLAND AVENUE Daphne AL 36577 2017-12-05 414.47 538 CHIQUITA CALDWELL 1501 BRIGGS COURT Normal AL 35762 2017-05-26 143.90 89 MONICA CANTRELL 697 ADAK CIRCLE Loachapoka AL 36865 2017-03-31 516.58

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock 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!

SQL CODE: 30. Write a query to display the first name, last name, phone number, title, and department number of employees who work in department 300 or have the title "CLERK I." Sort the output by...

SQL CODE: https://gist.githubusercontent.com/GistMasterPro/3893fe6d62ae301e85265a7f0ceafad4/raw/40fe8193dd74c39a56724d8eda2d445e41bc58c7/SQL.sql 30. Write a query to display the first name, last...

SQL CODE: https://gist.githubusercontent.com/GistMasterPro/3893fe6d62ae301e85265a7f0ceafad4/raw/40fe8193dd74c39a56724d8eda2d445e41bc58c7/SQL.sql OR...

LGCUSTOMER PK Cust Code Cust Frame Cust_Lname Cust Street Cust City Cust State PK FK1 Cust_ZIP Cust Balance places LGINVOICE Inv Num Cust Code Inv_Date Inv Total FK2 Employee ID completes LGEMPLOYEE...

The structure and contents of the Ch07_LargeCo database are shown in Figure P7.27 . Use this database to answer the following problems. 27. Write a query to display the eight departments in the...

' 39. Write a query to display the department number and most recent employee hire date for each department. Sort the output by department number ( Figure P7.39 ). 40. Write a query to display the...

The structure and contents of the Ch07_LargeCo database are shown in Figure P7.27 . Use this database to answer the following problems. 27. Write a query to display the eight departments in the...

53. LargeCo is planning a new promotion in Alabama (AL) and wants to know about the largest purchases made by customers in that state. Write a query to display the customer code, customer first name,...

1) LargeCo is planning a new promotion in Alabama (AL) and wants to know about the largest purchases made by customers in that state. Write a query to display the customer code, customer first name,...

LargeCo is planning a new promotion in Alabama (AL) and wants to know about the largest purchases made by customers in that state. Write a query to display the customer code, customer first name,...

The figure illustrates an all-wheel drive concept using three differentials, one for the front axle, another for the rear, and the third connected to the drive shaft. (a) Explain why this concept may...

Do markets produce a desirable allocation of resources? Or could the market outcome be improved upon?

Match the following terms and definitions. Capital investment The cash outflow needed to acc Capital investment decisions Decisions on whether to acquire Weighted average cost of capital The cost of...

QUESTION 4 (20 marks) In the context of capital projects, elaborate on the reasons why project managers are placing greater emphasis on investing in risk management.

7. Where Do We Begin?

2. More informal messages and short-circuiting of the hierarchy will occur. Organization structure and formal information flow will be redefined.

3. Are our bosses always right? If not, what should we do?