Answered: ; | bartleby

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

See similar textbooks

Related questions

Concept explainers

Question

What is the most a book has been sold for?

CREATE TABLE `volume` (
`inventory_id` int(11) NOT NULL,
`ISBN` char(17) DEFAULT NULL,
`condition_code` int(11) DEFAULT NULL,
`date_acquired` date DEFAULT NULL,
`asking_price` decimal(7,2) DEFAULT NULL,
`selling_price` decimal(7,2) DEFAULT NULL,
`sale_id` int(11) DEFAULT NULL
);

INSERT INTO `volume` (`inventory_id`, `ISBN`, `condition_code`, `date_acquired`, `asking_price`, `selling_price`, `sale_id`) VALUES
(1, '978-1-11111-111-1', 3, '2019-06-12', '175.00', '175.00', 1),
(2, '978-1-11111-131-1', 4, '2019-01-23', '50.00', '50.00', 1),
(3, '978-1-11111-133-1', 2, '2018-04-05', '300.00', '285.00', 1),
(4, '978-1-11111-142-1', 1, '2018-05-05', '25.95', '25.95', 2),
(5, '978-1-11111-146-1', 1, '2018-05-05', '22.95', '22.95', 2),
(6, '978-1-11111-144-1', 2, '2019-05-15', '80.00', '76.10', 2),
(7, '978-1-11111-137-1', 2, '2019-06-20', '80.00', NULL, NULL),
(8, '978-1-11111-137-1', 3, '2019-06-20', '50.00', NULL, NULL),
(9, '978-1-11111-136-1', 1, '2018-12-20', '75.00', NULL, NULL),
(10, '978-1-11111-136-1', 2, '2018-12-15', '50.00', NULL, NULL),
(11, '978-1-11111-143-1', 1, '2019-04-05', '25.00', '25.00', 3),
(12, '978-1-11111-132-1', 1, '2019-06-12', '15.00', '15.00', 3),
(13, '978-1-11111-133-1', 3, '2019-04-20', '18.00', '18.00', 3),
(14, '978-1-11111-121-1', 2, '2019-04-20', '110.00', '110.00', 3),
(15, '978-1-11111-121-1', 2, '2019-04-20', '110.00', '110.00', 5),
(16, '978-1-11111-121-1', 2, '2019-04-20', '110.00', NULL, NULL),
(17, '978-1-11111-124-1', 2, '2020-01-12', '75.00', NULL, NULL),
(18, '978-1-11111-146-1', 1, '2019-05-11', '30.00', '30.00', 6),
(19, '978-1-11111-122-1', 2, '2019-05-06', '75.00', '75.00', 6),
(20, '978-1-11111-130-1', 2, '2019-04-20', '150.00', '120.00', 6),
(21, '978-1-11111-126-1', 2, '2019-04-20', '110.00', '110.00', 6),
(22, '978-1-11111-139-1', 2, '2019-05-16', '200.00', '170.00', 6),
(23, '978-1-11111-125-1', 2, '2019-05-16', '45.00', '45.00', 7),
(24, '978-1-11111-131-1', 3, '2019-04-20', '35.00', '35.00', 7),
(25, '978-1-11111-126-1', 2, '2019-11-16', '35.00', '55.00', 8),
(27, '978-1-11111-141-1', 1, '2019-11-06', '24.95', NULL, NULL),
(28, '978-1-11111-141-1', 1, '2019-11-06', '24.95', NULL, NULL),
(29, '978-1-11111-141-1', 1, '2019-11-06', '24.95', NULL, NULL),
(30, '978-1-11111-145-1', 1, '2019-11-06', '27.95', NULL, NULL),
(31, '978-1-11111-145-1', 1, '2019-11-06', '27.95', NULL, NULL),
(32, '978-1-11111-145-1', 1, '2019-11-06', '27.95', NULL, NULL),
(33, '978-1-11111-139-1', 2, '2019-11-06', '75.00', '50.00', 9),
(34, '978-1-11111-133-1', 1, '2019-11-16', '125.00', '125.00', 10),
(35, '978-1-11111-126-1', 1, '2019-10-06', '75.00', '75.00', 11),
(36, '978-1-11111-130-1', 3, '2018-12-06', '50.00', '50.00', 11),
(37, '978-1-11111-136-1', 3, '2018-12-06', '75.00', '75.00', 11),
(38, '978-1-11111-130-1', 2, '2019-04-06', '200.00', '150.00', 12),
(39, '978-1-11111-132-1', 3, '2019-04-06', '75.00', '75.00', 12),
(40, '978-1-11111-129-1', 1, '2012-04-06', '25.95', '25.95', 13),
(41, '978-1-11111-141-1', 1, '2019-05-16', '40.00', '40.00', 14),
(42, '978-1-11111-141-1', 1, '2019-05-16', '40.00', '40.00', 14),
(43, '978-1-11111-132-1', 1, '2019-11-12', '17.95', NULL, NULL),
(44, '978-1-11111-138-1', 1, '2019-11-12', '75.95', NULL, NULL),
(45, '978-1-11111-138-1', 1, '2019-11-12', '75.95', NULL, NULL),
(46, '978-1-11111-131-1', 3, '2019-11-12', '15.95', NULL, NULL),
(47, '978-1-11111-140-1', 3, '2019-11-12', '25.95', NULL, NULL),
(48, '978-1-11111-123-1', 2, '2019-08-16', '24.95', NULL, NULL),
(49, '978-1-11111-127-1', 2, '2019-08-16', '27.95', NULL, NULL),
(50, '978-1-11111-127-1', 2, '2020-01-06', '50.00', '50.00', 15),
(51, '978-1-11111-141-1', 2, '2020-01-06', '50.00', '50.00', 15),
(52, '978-1-11111-141-1', 2, '2020-01-06', '50.00', '50.00', 16),
(53, '978-1-11111-123-1', 2, '2020-01-06', '40.00', '40.00', 16),
(54, '978-1-11111-127-1', 2, '2020-01-06', '40.00', '40.00', 16),
(55, '978-1-11111-133-1', 2, '2020-02-06', '60.00', '60.00', 17),
(56, '978-1-11111-127-1', 2, '2019-02-16', '40.00', '40.00', 17),
(57, '978-1-11111-135-1', 2, '2019-02-16', '40.00', '40.00', 18),
(58, '978-1-11111-131-1', 2, '2020-02-16', '25.00', '25.00', 18),
(59, '978-1-11111-127-1', 2, '2020-02-25', '35.00', '35.00', 18),
(60, '978-1-11111-128-1', 2, '2019-12-16', '50.00', '45.00', 19),
(61, '978-1-11111-136-1', 3, '2019-10-22', '50.00', '50.00', 19),
(62, '978-1-11111-115-1', 2, '2019-10-22', '75.00', '75.00', 20),
(63, '978-1-11111-130-1', 2, '2019-07-16', '500.00', NULL, NULL),
(64, '978-1-11111-136-1', 2, '2019-03-06', '125.00', NULL, NULL),
(65, '978-1-11111-136-1', 2, '2019-03-06', '125.00', NULL, NULL),
(66, '978-1-11111-137-1', 2, '2019-03-06', '125.00', NULL, NULL),
(67, '978-1-11111-137-1', 2, '2019-03-06', '125.00', NULL, NULL),
(68, '978-1-11111-138-1', 2, '2019-03-06', '125.00', NULL, NULL),
(69, '978-1-11111-138-1', 2, '2019-03-06', '125.00', NULL, NULL),
(70, '978-1-11111-139-1', 2, '2019-03-06', '125.00', NULL, NULL),
(71, '978-1-11111-139-1', 2, '2019-03-06', '125.00', NULL, NULL);

CREATE TABLE
sale
sale_id` int(11) NOT NULL,
customer_numb` int(11) DEFAULT NULL,
sale_date` date DEFAULT NULL,
sale_total_amt` decimal(8,2) DEFAULT NULL,
`credit_card_numb` char(20) DEFAULT NULL,
exp_month` int(11) DEFAULT NULL,
exp_year` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Dumping data for table `sale
sale_date`, ` sale_total_amt`, `credit_card_numb`, `exp_month`,
INSERT INTO `sale` (`sale_id`,
(1, 1, '2021-10-13', '510.00',
(2, 1, '2021-01-05',
(3, 1, '2021-06-15', '58.00',
(4, 4, '2021-06-30'
(5, 6, '2021-06-30', '110.00'
(6, 12, '2021-07-05', '505.00',
(7, 8, '2021-07-05', '80.00', '1234 5678 9101 8888', 8, 16),
(8, 5, '2021-07-07', '90.00', '1234 5678 9101 9999', 9, 15),
(9, 8, '2021-07-07', '50.00', '1234 5678 9101 8888', 8, 16),
(10, 11, '2021-07-10', '125.00', '1234 5678 9101 1010', 11, 16),
(11, 9, '2020-07-10', '200.00', '1234 5678 9101 0909',
(12, 10, ' 2021-07-10', '200.00'
(13, 2, '2021-07-10',
(14, 6, '2021-07-10',
(15, 11, '2021-07-12',
(16, 2, '2021-07-25', '130.00',
(17, 1, '2021-07-25', '100.00'
(18, 5, '2021-08-22', '100.00', '1234 5678 9101 9999', 9, 15),
(19, 6, '2021-09-01', '95.00',
(20, 2, '2021-09-01', '75.00'.
customer_numb`,
exp_year`) VALUES
'1234 5678 9101 1121', 10, 18),
'125.00', '1234 5678 9101 1121', 10, 18),
'1234 5678 9101 1121', 10, 18),
'1234 5678 9101 5555', 7, 17),
12, 17),
'1234 5678 9101 7777', 7, 16),
'110.00'
'1234 5678 9101 6666'
11, 15),
'1234 5678 9101 0101', 10, 15),
'1234 5678 9101 2222', 2, 15),
'1234 5678 9101 6666', 12, 17),
'1234 5678 9101 1231', 11, 17),
'1234 5678 9101 2222', 2, 15),
, 10, 18),
'25.95',
'80.00'
'75.00'
'1234 5678 9101 1121'
'1234 5678 9101 7777', 7, 16),
'1234 5678 9101 2222', 2, 15);

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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.