Question: Write an SQL query that will return the ISBNs and the acquired date of all volumes that were acquired in June, July, and August of
Write an SQL query that will return the ISBNs and the acquired date of all volumes that were acquired in June, July, and August of 2019
INSERT INTO `book` (`ISBN`, `work_numb`, `publisher_id`, `edition`, `binding`, `copyright_year`) VALUES ('978-1-11111-111-1', 1, 1, 2, 'Board', '1857'), ('978-1-11111-112-1', 1, 1, 1, 'Board', '1847'), ('978-1-11111-113-1', 2, 4, 1, 'Board', '1842'), ('978-1-11111-114-1', 3, 4, 1, 'Board', '1801'), ('978-1-11111-115-1', 3, 4, 10, 'Leather', '1925'), ('978-1-11111-116-1', 4, 3, 1, 'Board', '1805'), ('978-1-11111-117-1', 5, 5, 1, 'Board', '1808'), ('978-1-11111-118-1', 5, 2, 19, 'Leather', '1956'), ('978-1-11111-119-1', 6, 2, 3, 'Board', '1956'), ('978-1-11111-120-1', 8, 4, 5, 'Board', '1906'), ('978-1-11111-121-1', 8, 1, 12, 'Leather', '1982'), ('978-1-11111-122-1', 9, 1, 12, 'Leather', '1982'), ('978-1-11111-123-1', 11, 2, 1, 'Board', '1988'), ('978-1-11111-124-1', 12, 2, 1, 'Board', '1989'), ('978-1-11111-125-1', 13, 2, 3, 'Board', '1965'), ('978-1-11111-126-1', 13, 2, 9, 'Leather', '2001'), ('978-1-11111-127-1', 14, 2, 1, 'Board', '1960'), ('978-1-11111-128-1', 16, 2, 12, 'Board', '1960'), ('978-1-11111-129-1', 16, 2, 14, 'Leather', '2002'), ('978-1-11111-130-1', 17, 3, 6, 'Leather', '1905'), ('978-1-11111-131-1', 18, 4, 6, 'Board', '1957'), ('978-1-11111-132-1', 19, 4, 1, 'Board', '1962'), ('978-1-11111-133-1', 20, 4, 1, 'Board', '1964'), ('978-1-11111-134-1', 21, 5, 1, 'Board', '1964'), ('978-1-11111-135-1', 23, 5, 1, 'Board', '1962'), ('978-1-11111-136-1', 23, 5, 4, 'Leather', '2001'), ('978-1-11111-137-1', 24, 5, 4, 'Leather', '2001'), ('978-1-11111-138-1', 23, 5, 4, 'Leather', '2001'), ('978-1-11111-139-1', 25, 5, 4, 'Leather', '2001'), ('978-1-11111-140-1', 26, 5, 1, 'Board', '2001'), ('978-1-11111-141-1', 27, 5, 1, 'Board', '2005'), ('978-1-11111-142-1', 28, 5, 1, 'Board', '2008'), ('978-1-11111-143-1', 29, 5, 1, 'Board', '1992'), ('978-1-11111-144-1', 30, 1, 1, 'Board', '1952'), ('978-1-11111-145-1', 30, 5, 1, 'Board', '2001'), ('978-1-11111-146-1', 31, 5, 1, 'Board', '1999');
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help