Question: Solve both in Python jupyter nootebook : 1) 6 columns : date, customerid, product_quantity, sales, region, transaction_id. Which customer id bought maximum products? Tablename is

Solve both in Python jupyter nootebook :

1) 6 columns : date, customerid, product_quantity, sales, region, transaction_id. Which customer id bought maximum products? Tablename is questions.

(hint : get sales by multiplying product_quantity and price_per_item fields) 2)

Get sales during Christmas period (21 dec 2020 - 27 dec 2020) by region.

3)

Get count of transactions by region where customers had greater than 10000 $ sales and less than 10000 $ sales. (hint: create 2 columns for getting count of transaction ids - one where customers had greater than 10000 $ sales and another where customers had less than 10000 $ sales)

 Solve both in Python jupyter nootebook : 1) 6 columns :

pls solve as soon as possible

date 1 2 3 DOO AWN customerid product_quantity_price_per_item region transaction_id 10/9/2021 CC1 3 33 E 1 10/9/2021 CC1 4 22 A 2 12/26/2020 CC1 2 111 F 3 12/27/2020 CC2 1 22 G 4 12/28/2020 CC2 4 11000 G 5 12/29/2020 CC3 2 33 S 6 12/30/2020 CC3 1 22 S 7 10/9/2021 CC4 3 11000 E 8 10/10/2021 CC4 4 33 R 9 6 ON OOO 10 11

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!