By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
user_id | First_Name | Last_Name | Contact_Number | City | Address_1 | Address_2 | County | Postcode |
---|---|---|---|---|---|---|---|---|
2 | Homer | Simpson | 234475923 | Springfield | 742, Evergreen Terrace | null | Maine | PE02SN |
4 | Bruce | Wayne | 7893475629 | Gotham City | 1007, Mountain Drive | Batcave | Gotham | NG8 2AE |
6 | Tony | Stark | 9023853948 | Point Dume | 10880, Malibu Point | null | Malibu | MRVL616 |
7 | Sweeny | Todd | 923492734 | London | 186, Fleet Street | null | Greater London | 8DK92 |
37 | Spongebob | Squarepants | 293829493 | Bikini Bottom | 124, Conch Street | null | Pacific Ocean | 46BF9 |
49 | Jessica | Fletcher | 93829774 | Cabot Cove | 698, CAndlewood Lane | null | Maine | FN39F |
287 | Sherlock | Holmes | 2984723987 | London | 221B, Baker Street | null | Greater London | OFN38 |
2397 | Herman | Munster | 2593528955 | Mockingbird Heights | 1313, Mockingbird Lane | null | Los Angeles | NF93FN |
29374 | Phileas | Fogg | 234829384 | London | 7, Savile Row | Burlington Gardens | Greater London | 984NF |
73387 | Harry | Potter | 2387426 | Little Whinging | 4, Privet Drive | The Cupboard unda the Stairs | Surrey | FO9FH |
title | author_1 | author_2 | author_3 | author_4 | author_5 | author_6 | author_7 | author_8 | author_9 | author_10 | ISBN | stock |
---|---|---|---|---|---|---|---|---|---|---|---|---|
IT | Stephen King | null | null | null | null | null | null | null | null | null | 9780670813025 | 27 |
The Fantastic Art of Frank Frazetta | Frank Frazetta | Betty Ballantine | null | null | null | null | null | null | null | null | 9780684144160 | 1 |
Elantris | Brandon Sanderson | null | null | null | null | null | null | null | null | null | 9780765311771 | 12 |
Necronomicon | H. R. Giger | null | null | null | null | null | null | null | null | null | 9780905664064 | 8 |
Call of Cthulhu: Fantasy Roleplaying in the Worlds of HP Lovecraft | Sandy Petersen | null | null | null | null | null | null | null | null | null | 9780933635586 | 2 |
Vampire: The Masquerade | Phil Brucato | Tom Dowd | Mark Rein-Hagen | Richard E. Dansky | null | null | null | null | null | null | 9781565042490 | 4 |
Ghost in the Shell | Masamune Shirow | null | null | null | null | null | null | null | null | null | 9781569710814 | 5 |
Supergod | Warren Ellis | Garrie Gastonny | null | null | null | null | null | null | null | null | 9781592911004 | 6 |
Watchmen | Alan Moore | Dave Gibson | null | null | null | null | null | null | null | null | 9781852860240 | 15 |
Trigun | Yasuhiro Nightow | null | null | null | null | null | null | null | null | null | 9783551767011 | 2 |
user_id_loaned | ISBN_loaned | date_lent | due_date |
---|---|---|---|
49 | 9780684144160 | 1991-03-29 | 1991-05-29 |
287 | 9780933635586 | 1827-08-17 | 1827-10-17 |
2397 | 9780670813025 | 2022-05-10 | 2022-07-10 |
37 | 9780670813025 | 2022-04-19 | 2022-06-19 |
2397 | 9780905664064 | 2022-03-21 | 2022-05-21 |
29374 | 9781592911004 | 2022-05-16 | 2022-07-16 |
user_id_loaned | First_Name | Last_Name | title | ISBN_Loaned |
---|---|---|---|---|
2397 | Herman | Munster | IT | 9780670813025 |
37 | Spongebob | Squarepants | IT | 9780670813025 |
49 | Jessica | Fletcher | The Fantastic Art of Frank Frazetta | 9780684144160 |
2397 | Herman | Munster | Necronomicon | 9780905664064 |
287 | Sherlock | Holmes | Call of Cthulhu: Fantasy Roleplaying in the Worlds of HP Lovecraft | 9780933635586 |
29374 | Phileas | Fogg | Supergod | 9781592911004 |