В D H. PART C:Q.2 SOLVE THE FOLLOWING QUESTION 2 Size Color Current Ordered Received Qty Sum of order quantities greater than 35 B Large a Large 5 Large 5 Large Green 48 25-Apr 05-May 35 Sum of order quantities 35 or less Purple 18 08-Apr 18-Apr 20 Sum of all order quantities except 35 White 13 08-May 40 Black 63 25-Apr 05-May 45 Large Blue 12 08-May 40 Red B Large eMedium White 0 Medium Black 1 Medium Blue 2 Medium Purple 3 Medium Green 4 Medium Red Purple White 57 15-Apr 25-Apr 35 16 08-Apr 18-Apr 50 19 08-Apr 18-Apr 50 32 25-Apr 05-May 11-May 35 42 01-May 30 9 08-May 35 44 08-Apr 18-Apr 40 5 Small 59 15-Apr 25-Apr 40 6 Small 45 25-Apr 05-May 50 7 Small Red Black 32 15-Apr 40 8 Small 15 25-Apr 50 9 Small O Small Green Blue 41 15-Apr 25-Apr 45 39 15-Apr 25-Apr 40

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Solve the Excel Sheet attached with this question

A
D
E
F
G
H
1
PART C: Q.2 SOLVE THE FOLLOWING QUESTION
2 Size
3 Large
4 Large
Color
Current
Ordered Received Qty
Sum of order quantities greater than 35
Green
48
25-Apr
05-May
35
Sum of order quantities 35 or less
Purple
18
08-Apr
18-Аpr
20
Sum of all order quantities except 35
5 Large
6 Large
7 Large
8 Large
9 Medium White
10 Medium Black
11 Medium Blue
12 Medium Purple
White
13
08-May
40
Black
63
25-Apr
05-May
45
Blue
08-May
15-Apr
12
40
Red
57
25-Apr
35
16
08-Apr
18-Apr
50
19
08-Apr
18-Аpr
50
25-Apr
01-May
08-May
08-Apr
15-Apr
25-Аpr
32
05-May
35
42
11-May
30
13 Medium
Green
9
35
14 Medium Red
44
18-Apr
25-Apr
40
15 Small
Purple
59
40
16 Small
White
45
05-May
50
17 Small
Red
32
15-Apr
40
18 Small
19 Small
Black
15
25-Apr
50
25-Apr
25-Apr
Green
41
15-Аpr
45
20 Small
Blue
39
15-Apr
40
B.
Transcribed Image Text:A D E F G H 1 PART C: Q.2 SOLVE THE FOLLOWING QUESTION 2 Size 3 Large 4 Large Color Current Ordered Received Qty Sum of order quantities greater than 35 Green 48 25-Apr 05-May 35 Sum of order quantities 35 or less Purple 18 08-Apr 18-Аpr 20 Sum of all order quantities except 35 5 Large 6 Large 7 Large 8 Large 9 Medium White 10 Medium Black 11 Medium Blue 12 Medium Purple White 13 08-May 40 Black 63 25-Apr 05-May 45 Blue 08-May 15-Apr 12 40 Red 57 25-Apr 35 16 08-Apr 18-Apr 50 19 08-Apr 18-Аpr 50 25-Apr 01-May 08-May 08-Apr 15-Apr 25-Аpr 32 05-May 35 42 11-May 30 13 Medium Green 9 35 14 Medium Red 44 18-Apr 25-Apr 40 15 Small Purple 59 40 16 Small White 45 05-May 50 17 Small Red 32 15-Apr 40 18 Small 19 Small Black 15 25-Apr 50 25-Apr 25-Apr Green 41 15-Аpr 45 20 Small Blue 39 15-Apr 40 B.
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education