Question:
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 as0).
Transcribed Image Text:
Cust Code Cust FName Cust LName Cust Street Cust State Cust ZIPInv Date Largest Invoice 8/26/2011 6/21/2011 4/24/2011 903 ROBIN ADDISON 323 LORETTA PLACE 680 RED TALON DRIVE 829 BIG BEND LOOP Robertsdale 36574 36614 643 NINA 295 DORTHY 393 FOSTER BERNAL 1299 EAST 3RD AVENUE rmingham AUSTIN Diamond Shamrock AL 589.75 AL 372.68 853 GAYLORD BOLTON 1069 LUGENE LANE 925 ALANA 1248 LISA 538 CHIQUITA Montgomer Mccullough 36131 11/25/2011 36502 12/12/2011 36577 12/5/2011 5/26/2011 3/31/2011 BOOKER 1874 STREET 491 LOWLAND AVENUE Daphne CALDWELL 1501 BRIGGS COURT CANTRELL 8g MONICA 697 ADAK CIRCLE Loachapoka 36865 516.58 36303 11/24/2011 36033 12/29/2011 1233 NATHALE CHURCH 1802 SNOWY OWL CIRCLE Napier Field AL 304 GERTRUDE CONNORS 1042 PLEASANT DRIVE Georgiana 1131 CARMA CORNETT 767 CHISANA WAY 35645 10/25/2011