/SQLResult.json Secret
Created
March 5, 2019 13:29
JSON Result that emerged From SQL Query
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[ | |
{ | |
"title":"The Busy Executive's Database Guide", | |
"type":"business ", | |
"price":19.9900, | |
"advance":5000.0000, | |
"royalty":10, | |
"ytd_sales":4095, | |
"notes":"An overview of available database systems with emphasis on common business applications. Illustrated.", | |
"pubdate":"1991-06-12T00:00:00", | |
"Authors":[ | |
{ | |
"au_fname":"Marjorie", | |
"au_lname":"Green", | |
"phone":"415 986-7020", | |
"address":"309 63rd St. #411", | |
"city":"Oakland", | |
"state":"CA", | |
"zip":"94618", | |
"contract":true, | |
"au_ord":2, | |
"royaltyper":40 | |
}, | |
{ | |
"au_fname":"Abraham", | |
"au_lname":"Bennet", | |
"phone":"415 658-9932", | |
"address":"6223 Bateman St.", | |
"city":"Berkeley", | |
"state":"CA", | |
"zip":"94705", | |
"contract":true, | |
"au_ord":1, | |
"royaltyper":60 | |
} | |
], | |
"publisher":[ | |
{ | |
"pub_name":"Algodata Infosystems", | |
"city":"Berkeley", | |
"state":"CA", | |
"country":"USA" | |
} | |
], | |
"RoyaltyShedule":[ | |
{ | |
"lorange":0, | |
"hirange":5000, | |
"royalty":10 | |
}, | |
{ | |
"lorange":5001, | |
"hirange":50000, | |
"royalty":12 | |
} | |
], | |
"Sales":[ | |
{ | |
"stor_name":"Eric the Read Books", | |
"stor_address":"788 Catamaugus Ave.", | |
"city":"Seattle", | |
"state":"WA", | |
"ord_num":"6871", | |
"ord_date":"1994-09-14T00:00:00", | |
"qty":5, | |
"payterms":"Net 60", | |
"title_id":"BU1032" | |
}, | |
{ | |
"stor_name":"Bookbeat", | |
"stor_address":"679 Carson St.", | |
"city":"Portland", | |
"state":"OR", | |
"ord_num":"423LL930", | |
"ord_date":"1994-09-14T00:00:00", | |
"qty":10, | |
"payterms":"ON invoice", | |
"title_id":"BU1032" | |
} | |
] | |
} | |
] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment