Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Question 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)

image text in transcribed

solve using sql

F G I . I date NON 00 5 A B D E F 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 9 10 11 12

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

Automating Access Databases With Macros

Authors: Fish Davis

1st Edition

1797816349, 978-1797816340

More Books

Students also viewed these Databases questions