Describe the query you would run to determine which customers
have placed an order but still haven't paid. What values from each
table need to be used?
Describe The Query You Would Run To Determine Which Customers Have Placed An Order But Still Haven T Paid What Values F 1 (268.08 KiB) Viewed 48 times
ID First Name 1 Tracey 2 Lucinda 3 Jerrod 4 Brett 5 Chloe 6 Quinton 7 Alex 8 Nisha 9 Hillary 10 Kiara 11 Katy 12 Beatrix 13 Mariah 14 Jennifer 15 Jaleel 16 Cody 17 Amaya 18 Cynthia 19 Cindy 20 Barbara 29 Bob 30 Juanita 31 Sara 32 Larry 33 Samantha 35 Patti 36 Greg 37 Carol 38 Zoey Last Name Beckham George Smith Newkirk Jones Boyd Hinton Hall Clayton Williams Jones Joslin Allen Hill Smith Hayes Gibson Love Freeman Jameson Jones Williams Thomas Binder Ferguson Cheng Newton Allenson Altman fl Street Address 7 East Walker Dr. 789 Brewer St. 211 St. George Ave. 47 Hillsborough St. 23 Solo Ln. 4 Cypress Cr. 1011 Hodge Ln. 123 Huntington St. 2516 Newman 9014 Miller Ln. 456 Denver Rd. 85 North West St. 12 Jupe 2100 Field Ave. 123 Hill Top Drive 65 North St. 5 West St. 7825 Venice Ct. 78-A Meadowview Ln. 29 North Luke Ct. 63-C Chapel Ct. 123 Garden Plow Way 127 South Pejulup Ln. 124 Heuristic Way 2380 New Cove Rd. 9 Atlantic Blvd 2520 Hopkins Rd. 3201 Glenwood Ave. Unit A 817 Hillsborough St. Apt E102 303 C-d City Raleigh Cary Raleigh Raleigh Raleigh Durham Cary Raleigh Raleigh Durham Cary Raleigh Raleigh Raleigh Garner Raleigh Raleigh Raleigh Raleigh Raleigh Durham Raleigh Raleigh Raleigh Garner Raleigh Raleigh Raleigh Raleigh D-I-:-L NC NC NC NC NC NC NC NC NC NC NC NC NC NC NC NC NC NC NC NC NC NC NC NC NC NC NC NC NC State Zip Code 27612 27513 27610 27608 27609 27714 27513 27612 27606 27713 27513 27606 27605 27609 27610 27609 27612 27605 27609 27609 27714 27609 27603 27609 27529 27608 27615 27607 27605 37000 Email [email protected][email protected][email protected][email protected][email protected][email protected][email protected][email protected][email protected][email protected][email protected][email protected][email protected][email protected][email protected][email protected][email protected][email protected][email protected][email protected][email protected][email protected][email protected][email protected][email protected][email protected][email protected][email protected][email protected] Add to Mailing List? No Yes- Weekly No No No Yes- Weekly No Yes- Special Offers Only No Yes- Weekly No Yes- Special Offers Only No No No No Yes- Special Offers Only Yes- Special Offers Only No No No No No Yes- Special Offers Only No No No Yes- Special Offers Only No Phone Numbel 919-555-2314 919-555-4534 919-555-4564 919-555-7653 919-555-8658 919-555-5112 919-555-5460 919-555-5753 919-555-9745 919-555-8975 919-555-2332 919-555-1123 919-555-3432 919-555-5467 919-555-7755 919-555-5434 919-555-7565 919-555-4655 919-555-7890 919-555-2222 919-555-2121 919-555-4334 919-555-5643 919-555-5657 919-555-6576 919-555-6666 919-555-4585 919-555-7575 919-555-6688 010 FE 7770
ID 5 6 7 8 9 10 || 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Customer ID 44 136 131 145 47 38 92 38 139 130 129 124 163 96 78 153 71 176 149 96 10 100 125 104 97 101 44 Paid TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE Pre Order Notes FALSE TRUE For a birthday party-- cake should read, "Happy Birthday, Daddy!" FALSE TRUE For a reception at the J. Ikiba Gallery FALSE FALSE TRUE For a holiday party FALSE TRUE For a kindergarten party. Write, "Happy 6th Birthday, Matthew!" on the cake and draw a rabbit in icing next to the text. FALSE TRUE For a holiday party FALSE FALSE FALSE For a Christmas party FALSE Cake should read, "Congratulations, Yuki!" FALSE TRUE For an office party FALSE Extra icing FALSE TRUE Decorate cake with the following names: "Edouard," "Arnaud," "Erwan," "Celine," and "Camille" TRUE Christmas TRUE Add text, "Joyeaux Noël 2010" TRUE Christmas- Write "Happy Birthday Jesus" on the Carrot Cake TRUE Christmas- Tie boxes up with ribbon TRUE Christmas- write "Merry Christmas to All" on the cake. Vary decorative Hooray! the cakes-- different colored flowers, placement of moss, TRUE etc TRUE Pickup Date 04-Dec-20 09-Dec-20 04-Dec-20 10-Dec-20 14-Dec-20 15-Dec-20 15-Dec-20 16-Dec-20 16-Dec-20 17-Dec-20 17-Dec-20 17-Dec-20 18-Dec-20 18-Dec-20 18-Dec-20 18-Dec-20 19-Dec-20 18-Jan-20 20-Dec-20 23-Dec-20 23-Dec-20 23-Dec-20 23-Dec-20 23-Dec-20 23-Dec-20 Dec-20 24-Dec-20 Got it! Your file is now in Google Sheets format. Click the Share button to start editing
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!