Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SQL Queries. Write a query that will list the customer(s) who had ordered the maximum number of items (2 copies of the same book will

SQL Queries.

Write a query that will list the customer(s) who had ordered the maximum number of items (2 copies of the same book will be counted as 2 items).

CUSTOMER table:

image text in transcribed

BOOKORDER table:

image text in transcribed

BOOKORDERITEM table:

image text in transcribed

11 14 15 17 19 CUST-NUM CUST-LNAME CUST FNAME CUST-ADDRESS CUST-CITY CUST-STATE CUST-ZIP CUST-REFERRED 1001, MORALES BONITA P. O. BOX 651 EAST POINT 32328 null. 1002 THOMPSON RYAN P.0. BOX 9835 SANTA MONICA CA 90404 null. 1003 SMITH LEILA BOX 66 ALLAHASSEE FL 32306 null. 1004 PIERSON THOMAS 69821 SOUTH AVENUE BOISE 83707 null. 1005 GIRARD CINDY SEATTLE WA P.0. BOX 851 98115 null. ALBANY NY 1006 CRUZ 82 DIRT ROAD MESHIA. 12211 null. 9153 MAIN STREET AUSTIN Tx 1007 GIANA TAMMY 78710 1003 KENNETH P.0. Box 137 1008 JONES CHEYENNE 82003 null. P.0. Box 8564 BURBANK CA 1009 PEREZ JORGE 91510 1003 GA 114 EAST SAVANNAH ATLANTA 1010 LUCAS JAKE 30314 null. CHICAGO IL 1011 MCGOVERN REESE BOX 18 60606 null. 1012 MCKENZIE WILLIAM P. o. BOX 971 MA BOSTON 02110 null. NICHOLAS 357 WHITE EAGLE AVE. CLERMONT FL 1013 NGUYEN 34711 1006 JASMINE P.0. Box 2947 copy 1014 LEE 82414 null. 1015 SCHELL P.0. BOX 677 STEVE MIAMI 33111 null. MICHELL 9851231 LONG ROAD BURBANK CA 1016 DAUM 91508 1010 BECCA P.0. Box 563 KALMAzoo MI 1017 NELSON 49006 null. 1008 GRAND AVENUE MACON GA 1018 MONTIASA GREG 31206 null. JENNIFER P. o. Box 1151 1019 SMITH RRISTOWN NJ 07962 1003 KENNETH P. o. Box 335 TRENTON NJ 1020 FALAH 08607 null

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Securing SQL Server Protecting Your Database From Attackers

Authors: Denny Cherry

3rd Edition

0128012757, 978-0128012758

More Books

Students also viewed these Databases questions

Question

=+ Of the HR issues mentioned in the case,

Answered: 1 week ago