How do I list  titles, cost, retail and profit margin for all books that have a profit margin under 55% in SQL?

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

How do I list  titles, cost, retail and profit margin for all books that have a profit margin under 55% in SQL? 

Results Explain Describe Saved SQL History
1059831198
0401140733
4981341710
8843172113
8843172115
3437212490
3957136468
1915762492
9959789321
2491748320
0299282519
8117949391
ISBN
BODYBUILD IN 10 MINUTES A DAY
REVENGE OF MICKEY
BUILDING A CAR WITH TOOTHPICKS
DATABASE IMPLEMENTATION
DATABASE IMPLEMENTATION
COOKING WITH MUSHROOMS
HOLY GRAIL OF ORACLE
HANDCRANKED COMPUTERS
E-BUSINESS THE EASY WAY
PAINLESS CHILD-REARING
THE WOK WAY TO COOK
BIG BEAR AND LITTLE DOVE
TITLE
PUBDATE
21-Jan-2014
14-Dec-2014
18-Mar-2015
04-Jun-2012
04-Jun-2012
28-Feb-2013
31-Dec-2014
21-Jan-2014
01-Mar-2015
17-Jul-2013
11-Sep-2013
08-Nov-2014
4
1
2
3
3
4
3
3
2
5
4
5
PUBID
18.75
14.2
37.8
31.4
31.4
12.5
47.25
21.8
37.9
48
19
5.32
COST
30.95
22
59.95
55.95
55.95
19.95
75.95
25
54.5
89.95
28.75
8.95
RETAIL
3
3.8
4.5
DISCOUNT
FITNESS
CATEGORY
FAMILY LIFE
CHILDREN
COMPUTER
COMPUTER
COOKING
COMPUTER
COMPUTER
COMPUTER
FAMILY LIFE
Cooking
CHILDREN
5
50
30
2
1
100
0
26
60
3
6
4
QOH
Transcribed Image Text:Results Explain Describe Saved SQL History 1059831198 0401140733 4981341710 8843172113 8843172115 3437212490 3957136468 1915762492 9959789321 2491748320 0299282519 8117949391 ISBN BODYBUILD IN 10 MINUTES A DAY REVENGE OF MICKEY BUILDING A CAR WITH TOOTHPICKS DATABASE IMPLEMENTATION DATABASE IMPLEMENTATION COOKING WITH MUSHROOMS HOLY GRAIL OF ORACLE HANDCRANKED COMPUTERS E-BUSINESS THE EASY WAY PAINLESS CHILD-REARING THE WOK WAY TO COOK BIG BEAR AND LITTLE DOVE TITLE PUBDATE 21-Jan-2014 14-Dec-2014 18-Mar-2015 04-Jun-2012 04-Jun-2012 28-Feb-2013 31-Dec-2014 21-Jan-2014 01-Mar-2015 17-Jul-2013 11-Sep-2013 08-Nov-2014 4 1 2 3 3 4 3 3 2 5 4 5 PUBID 18.75 14.2 37.8 31.4 31.4 12.5 47.25 21.8 37.9 48 19 5.32 COST 30.95 22 59.95 55.95 55.95 19.95 75.95 25 54.5 89.95 28.75 8.95 RETAIL 3 3.8 4.5 DISCOUNT FITNESS CATEGORY FAMILY LIFE CHILDREN COMPUTER COMPUTER COOKING COMPUTER COMPUTER COMPUTER FAMILY LIFE Cooking CHILDREN 5 50 30 2 1 100 0 26 60 3 6 4 QOH
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Multiple table
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.
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