SQL List the item number in lower case, description in upper case, order date 30 days later (add 30 days to order date), and the total price (which is number ordered times the quoted price). Rename the calculation as Total_Price and round to the nearest dollar.

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
icon
Concept explainers
Question

SQL

List the item number in lower case, description in upper case, order date 30 days later (add 30 days to order date), and the total price (which is number ordered times the quoted price). Rename the calculation as Total_Price and round to the nearest dollar.

REP
REP_NUM LAST_NAME FIRST_NAME STREET
CITY
STATE POSTAL_CODE COMMISSION
RATE
$23,457.50
$41,317.00
$27,789.25
$0.00
15
Rafael
724 Vinca Dr.
Grove
СА
90092
Campos
Gradey
0.06
632 Liatris St. Fullton
1785 Tyler Ave. Northfield
267 Oakley St. Congaree
30
Megan
СА
90085
0.08
45
Tian
Hui
CA
90098
0.06
60
Sefton
Janet
СА
90097
0.06
CUSTOMER
CUSTOMER_NUM CUSTOMER_NAME STREET
28 Laketon St.
CITY
STATE POSTAL_CODE BALANCE CREDIT_LIMIT REP_NUM
$7,500.00 15
$10,000.00 30
$7,500.00 45
126
Toys Galore
Fullton
CA
90085
$1,210.25
260
Brookings Direct
452 Columbus Dr. Grove
СА
90092
$575.00
342 Magee St.
The Everything
Shop
334
Congaree CA
90097
$2,345.75
386
Johnson's
124 Main St.
Northfield CA
90098
$879.25
$7,500.00 30
Department
Store
440
Grove
3456 Central Ave. Fullton
СА
90085
$345.00
$5,000.00 45
Historical
Museum Store
502
Cards and More
167 Hale St.
Mesa
СА
90104
$5,025.75
$5,000.00 15
Almondton
586
3345 Devon Ave.
Almondton CA
90125
$3,456.75
$15,000.00 45
General Store
665
Cricket Gift Shop 372 Oxford St.
Grove
CA
90092
$678.90
$7,500.00 30
12 Rising Sun Ave. Congaree CA
Northfield CA
$10,000.00 15
$7,500.00 45
713
Cress Store
90097
$4,234.60
796
Unique Gifts
786 Passmore St.
90098
$124.75
824
Kline's
945 Gilham St.
Mesa
CA
90104
$2,475.99
$15,000.00 30
893
All Season Gifts
382 Wildwood Ave. Fullton
СА
90085
$935.75
$7,500.00 15
Transcribed Image Text:REP REP_NUM LAST_NAME FIRST_NAME STREET CITY STATE POSTAL_CODE COMMISSION RATE $23,457.50 $41,317.00 $27,789.25 $0.00 15 Rafael 724 Vinca Dr. Grove СА 90092 Campos Gradey 0.06 632 Liatris St. Fullton 1785 Tyler Ave. Northfield 267 Oakley St. Congaree 30 Megan СА 90085 0.08 45 Tian Hui CA 90098 0.06 60 Sefton Janet СА 90097 0.06 CUSTOMER CUSTOMER_NUM CUSTOMER_NAME STREET 28 Laketon St. CITY STATE POSTAL_CODE BALANCE CREDIT_LIMIT REP_NUM $7,500.00 15 $10,000.00 30 $7,500.00 45 126 Toys Galore Fullton CA 90085 $1,210.25 260 Brookings Direct 452 Columbus Dr. Grove СА 90092 $575.00 342 Magee St. The Everything Shop 334 Congaree CA 90097 $2,345.75 386 Johnson's 124 Main St. Northfield CA 90098 $879.25 $7,500.00 30 Department Store 440 Grove 3456 Central Ave. Fullton СА 90085 $345.00 $5,000.00 45 Historical Museum Store 502 Cards and More 167 Hale St. Mesa СА 90104 $5,025.75 $5,000.00 15 Almondton 586 3345 Devon Ave. Almondton CA 90125 $3,456.75 $15,000.00 45 General Store 665 Cricket Gift Shop 372 Oxford St. Grove CA 90092 $678.90 $7,500.00 30 12 Rising Sun Ave. Congaree CA Northfield CA $10,000.00 15 $7,500.00 45 713 Cress Store 90097 $4,234.60 796 Unique Gifts 786 Passmore St. 90098 $124.75 824 Kline's 945 Gilham St. Mesa CA 90104 $2,475.99 $15,000.00 30 893 All Season Gifts 382 Wildwood Ave. Fullton СА 90085 $935.75 $7,500.00 15
ORDERS
ORDER_LINE
ORDER_DATE CUSTOMER_NUM ORDER_NUM ITEM_NUM
CD33
ORDER_NUM
NUM_ORDERED QUOTED_PRICE
51608
$86.99
51608
10/12/2015
126
51610
KL78
25
$10.95
51610
10/12/2015 334
51610
TR40
10
$13.99
51613
10/13/2015 386
51613
DL51
$104.95
10/13/2015 | 260
10/15/2015 | 586
51614
51614
FD11
1
$124.95
51617
51617
NL89
$115.99
51619
10/15/2015
126
51617
TW35
$116.95
51619
FD11
$121.95
10/15/2015 586
10/16/2015 796
51623
51623
DR67
$29.95
51625
51623
FH24
12
$36.95
51623
KD34
10
$13.10
51625
МТОЗ
$45.79
ITEM
ITEM_NUM DESCRIPTION
ON_HAND CATEGORY
STOREHOUSE
PRICE
АН74
Patience
9 GME
3.
$22.99
BR23
Skittles
21 GME
$29.99
CD33
Wood Block Set (48 piece)
36 TOY
1
$89.49
DL51
Classic Railway Set
12 TOY
3
$107.95
DR67
Giant Star Brain Teaser
24 PZL
2
$31.95
DW23
Mancala
40 GME
3
$50.00
FD11
Rocking Horse
8 TOY
3
$124.95
FH24
Puzzle Gift Set
65 PZL
1
$38.95
KA12
Cribbage Set
56 GME
$75.00
KD34
Pentominoes Brain Teaser
60 PZL
$14.95
KL78
Pick Up Sticks
110 | GME
1
$10.95
MT03
Zauberkasten Brain Teaser
45 PZL
1
$45.79
NL89
Wood Block Set (62 piece)
32| ТOY
3
$119.75
TR40
Tic Tac Toe
75 GME
2
$13.99
TW35
Fire Engine
30 TOY
2
$118.95
4.
2.
Transcribed Image Text:ORDERS ORDER_LINE ORDER_DATE CUSTOMER_NUM ORDER_NUM ITEM_NUM CD33 ORDER_NUM NUM_ORDERED QUOTED_PRICE 51608 $86.99 51608 10/12/2015 126 51610 KL78 25 $10.95 51610 10/12/2015 334 51610 TR40 10 $13.99 51613 10/13/2015 386 51613 DL51 $104.95 10/13/2015 | 260 10/15/2015 | 586 51614 51614 FD11 1 $124.95 51617 51617 NL89 $115.99 51619 10/15/2015 126 51617 TW35 $116.95 51619 FD11 $121.95 10/15/2015 586 10/16/2015 796 51623 51623 DR67 $29.95 51625 51623 FH24 12 $36.95 51623 KD34 10 $13.10 51625 МТОЗ $45.79 ITEM ITEM_NUM DESCRIPTION ON_HAND CATEGORY STOREHOUSE PRICE АН74 Patience 9 GME 3. $22.99 BR23 Skittles 21 GME $29.99 CD33 Wood Block Set (48 piece) 36 TOY 1 $89.49 DL51 Classic Railway Set 12 TOY 3 $107.95 DR67 Giant Star Brain Teaser 24 PZL 2 $31.95 DW23 Mancala 40 GME 3 $50.00 FD11 Rocking Horse 8 TOY 3 $124.95 FH24 Puzzle Gift Set 65 PZL 1 $38.95 KA12 Cribbage Set 56 GME $75.00 KD34 Pentominoes Brain Teaser 60 PZL $14.95 KL78 Pick Up Sticks 110 | GME 1 $10.95 MT03 Zauberkasten Brain Teaser 45 PZL 1 $45.79 NL89 Wood Block Set (62 piece) 32| ТOY 3 $119.75 TR40 Tic Tac Toe 75 GME 2 $13.99 TW35 Fire Engine 30 TOY 2 $118.95 4. 2.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 6 images

Blurred answer
Knowledge Booster
Query Syntax
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
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