Question: SQL Help!! Three part question: 1. List Top 10 customers by their names who ordered the most quantity and their country of origin. (double inner

SQL Help!!

Three part question:

1. List Top 10 customers by their names who ordered the most quantity and their country of origin. (double inner join)

2. List top 5 customers of from Canada that placed the most orders (quantity). (double inner join)

3. Order top 20 customer from United States and China who placed the most order (Quantity) according to their order date from earliest to latest. Also, report the country of origin.

Photos of the database below:

SQL Help!! Three part question: 1. List Top 10 customers by their

names who ordered the most quantity and their country of origin. (double

inner join) 2. List top 5 customers of from Canada that placed

the most orders (quantity). (double inner join) 3. Order top 20 customer

from United States and China who placed the most order (Quantity) according

to their order date from earliest to latest. Also, report the country

of origin. Photos of the database below: ormation schoma tim60 nation orders

part pantsupp region supplie Current selection does nat contain a Grid edit

ormation schoma tim60 nation orders part pantsupp region supplie Current selection does nat contain a Grid edit eckbox, Edit, Copy d Delete features lable. Showing rows 0.24 (1500 total Query took 0.1031 seconds.) Ic oomments: BLOB-57 B BLOB-49 BI a I Number of raws 25 a Fiber rows: Search table Options c attbal c mktseg sticey c na c nation key c phone 020 Customer4000001020 DHom.LSHKIYSwLSZv39AooYQHIvbaeztefwR 3 13-692-286.8158 6914.87 MACHINERY 337 Customer 000001337 ACAM Jo2xdw2BCgHrGMdOBX 22 32-628-594 1931 788244 MACHINERY 7 17-573-775.8796 876.02 HOUSEHOLD 14B0 Customer 000001480 Hzih65ZXBFSzlitjogECkrp35gDhe,2 388 Customer oo0000355 205raxg9ZWPZNX1z 4 24 656.787.6091 8727 90 FURNITURE 91 Customer+00000 9 29-587.244 2901 9068.54 AUTOMOBILE 989 Customer 000000989 pKubewbHexZFJYouZGiooRaH1XI 020 646-819 6327 5443.74 AUTOMOBILE 57 Customert000000057 97XYbsuOPAXPWU 21 31-835-306-1650 4151.93 AUTOMOBILE 208 Customer 000000208 AbyelMwcNfYoKosyqv.Wwa 9 298 9-139 6234 6239U88 MACHINERY 388 Customer+000001388 WakdgWEru70hsLBnyLeEknehlyM59Lboo5zfww 3 23-185-747 9502 291.44 FURNITURE 57 Customor20000001 57 5 25.207.442.1556 9768.73 BUILDING 73 Customert000000173 Aue7KV2.FinSHpov Vksed,wSQ2BRSioJ0 BUILDING 9 19-443-196-8008 845.84 489 Customer oo0001489 yM8bilU5lFKHODCGT 9 19-906-669 4354 4388.66 MACHINERY 545 Customer#000000545 0 20-849-123.8918 7505.33 AUTOMOBILE 656 Customer 2000000656 DoZPoc2K1 515 379.993.4446 390.09 AUTOMOBILE 435 CustomerH000001435 s0fiqodkVVqLWR laqibwwOf 20 30-309-437-92B5 -729.09 AUTOMOBILE 650 Customer oo0000650 1hqwYdlDhaqnkRinovbuloorrDhJzguz 5 15 BA2 586.1263 20B691 AUTOMOBILE 210 Customerp000001210 bUTLW1 B 28-202-315.9048 8137 B8 AUTOMOBILE 962 Customer oo0000962 IDp572 Gdr134KB YoQuC 4 14 792.232.1645 7557.00 BUILDING 589 Customeri000000569 Kk20Q5HiysicPpMILBpNUZXXuE 212-848-587-8778 -795.23 MACHINERY 012 Customer oo0001012 5Zsp rqM6acmgqqFe 4 14 535.551.6255 4422.45 AUTOMOBILE 411 CustomerH0000004 828-483-924-1955 1200.32 HOUSEHOLD 26-350-231 6183 4033.5E MACHINERY 296 Customer 000001296 cLAyTJcD3T4hKW52IU9yk 5 15-130-485-1234 30 4.89 MACHINERY 412 customeraoooooo412 5 N2Yorhi 22 32.940.3 18.3191 6044 2 BUILDING 428 Customeri000000A 21 31-587-557 82 952.38 BUILDING accounts about the carefully ironic instructions h. accounts about tho ironic roquests wako always b accounts about the slyly final pinto beans integra... accounts affix furiously carefully caroful Tiro accounts allix quicky regular packages blthely accounts are bltholy across tho rogular doposits. accounts are quickly regular pinto beans subla accounts boost carefully. ironic, rogular packages accounts boost slyly after the sl accounts cajola. always regular requests cajola accounts doubt blithely unusual platelets. packa accounts engage inside tho blithely final dop accounts from the slyly express pinto beans nag ca. accounts hagglo blithaly syly unusual accounts. accounts haggle blithely. foxes in place of the bo accounts hagglo enticingly slyly regular accounts. accounts haggle slyly even acc accounts in place of regular requests cajole c accounts run busily within the bold accounts sleep slyly quickly ironic depasits abov. accounts snooze blithely final, special ideas eve against the silently expr accounts thrash upon the blithely regular requests. accounts use according to the blithely aven requ accounts use sient, special accounts, furtiy p Profiling Edit inlino

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!