build a table

- e x Rep RepNut. LastNam FirstNam. 20 Kaiser Valerie - 35 Hull Richard 65 Perez Juan Street City Stat - Zip - Commissio- 624 Randall Grove FL 33321 $20,542.50 532 Jackson Sheldon FL 33553 $39,216.00 1626 Taylor Fillmore FL 33336 $23,487.00 Cust CustNum- CustName - City Balance CreditLimit RepNum - Clica 1 Dasher Snowville $1,000 $7,500 65 - 10 Mr. Clause Whiteout $1,500 $10,000 20 2 Dancer Whiteout $2,000 $7,500 20 . Prancer Coldville $1,500 $15,000 35 Vixon North Pole $1,000 $5,000 65 5 Comet Chill $2,000 $7,500 65 Cupid North Pole $1,000 $7,500 65 7 Donner Winter $1,500 $5,000 35 +8 Blitzen Chill $2,500 $10,000 65 +9 Rudolph Red Nose $1,000 $15,000 35 Part Orders Orderu Order Date Customer nur Part Nur- Desc - Onhan - Class - 1 1/1/20202 AT94 Lights 10 House -2 2/1/20201 *CDS2 Ornaments 6 House -3 3/1/2020 10 - L71 Candles 7 House 4/1/2020 -OW11 Sled 15 Gift -5 5/1/20201 ELO4 Blocks 5 Toy -6 6/1/20203 FD21 Trains 20 Gift +7 7/1/20208 + KL62 Snowman 10 Toy - KT03 Reindeer 5 Toy Onderline RD20 Snow Globes 7 House Order Num - PartNur NumOrdere. QuotedPric- - TR10 Trees 7 House 2 AT94 2 $10.00 Recorde 1 of 10 Search 2 DW11 8 $25.00 Z TR10 2 $14.00 3 KLOZ 6 $35.00 TR10 4 $17.00 4 KTO3 2 $22.00 TRIO 1 $15.00 KL62 4 $15.00 RD20 2 $18.00 6 TR10 6 $17.00 AT94 2 $25.00 Price - $15.00 $25.00 $10.00 $20.00 $10.00 $15.00 $20.00 $10.00 $10.00 $15.00 SQL Question Answer CustName Tanco The Name credelimit Show IS Part Desc On hand ha Part Tabeant Sort Cust Custum ty Total Credit Limit Cust sum Table Cust Total Group By Son Show Criteria North Poleh ST - e x Rep RepNut. LastNam FirstNam. 20 Kaiser Valerie - 35 Hull Richard 65 Perez Juan Street City Stat - Zip - Commissio- 624 Randall Grove FL 33321 $20,542.50 532 Jackson Sheldon FL 33553 $39,216.00 1626 Taylor Fillmore FL 33336 $23,487.00 Cust CustNum- CustName - City Balance CreditLimit RepNum - Clica 1 Dasher Snowville $1,000 $7,500 65 - 10 Mr. Clause Whiteout $1,500 $10,000 20 2 Dancer Whiteout $2,000 $7,500 20 . Prancer Coldville $1,500 $15,000 35 Vixon North Pole $1,000 $5,000 65 5 Comet Chill $2,000 $7,500 65 Cupid North Pole $1,000 $7,500 65 7 Donner Winter $1,500 $5,000 35 +8 Blitzen Chill $2,500 $10,000 65 +9 Rudolph Red Nose $1,000 $15,000 35 Part Orders Orderu Order Date Customer nur Part Nur- Desc - Onhan - Class - 1 1/1/20202 AT94 Lights 10 House -2 2/1/20201 *CDS2 Ornaments 6 House -3 3/1/2020 10 - L71 Candles 7 House 4/1/2020 -OW11 Sled 15 Gift -5 5/1/20201 ELO4 Blocks 5 Toy -6 6/1/20203 FD21 Trains 20 Gift +7 7/1/20208 + KL62 Snowman 10 Toy - KT03 Reindeer 5 Toy Onderline RD20 Snow Globes 7 House Order Num - PartNur NumOrdere. QuotedPric- - TR10 Trees 7 House 2 AT94 2 $10.00 Recorde 1 of 10 Search 2 DW11 8 $25.00 Z TR10 2 $14.00 3 KLOZ 6 $35.00 TR10 4 $17.00 4 KTO3 2 $22.00 TRIO 1 $15.00 KL62 4 $15.00 RD20 2 $18.00 6 TR10 6 $17.00 AT94 2 $25.00 Price - $15.00 $25.00 $10.00 $20.00 $10.00 $15.00 $20.00 $10.00 $10.00 $15.00 SQL Question Answer CustName Tanco The Name credelimit Show IS Part Desc On hand ha Part Tabeant Sort Cust Custum ty Total Credit Limit Cust sum Table Cust Total Group By Son Show Criteria North Poleh ST