my code stock.com

Snippet options

Download: Download snippet as querys.sql.
Copy snippet: For this you need a free my code stock.com account.
Embed code : You will find the embed code for this snippet at the end of the page, if you want to embed it into a website or a blog!

UPDATE LOAN_HISTORY
SET DATE_DUE= '12/25/2013'
WHERE LOAN_ID = 'AD331';

UPDATE LOAN_HISTORY
SET BOOK_ID = 'LS23'
WHERE LOAN_ID = 'AD331';

UPDATE LOAN_HISTORY
SET DATE_RETURNED = ''
WHERE LOAN_ID = 'AD331';

UPDATE LOAN_HISTORY
SET LIBRARIAN_OUT = '1'
WHERE LOAN_ID = 'AD331';

UPDATE LOAN_HISTORY
SET DATE_ISSUED = '12/11/2013'
WHERE LOAN_ID = 'AD331';

COMMIT;

SELECT BOOK_ID, AUTHOR.AUTHOR_ID, LAST_NAME, FIRST_NAME
FROM BOOK_AUTHOR, AUTHOR
WHERE  AUTHOR.AUTHOR_ID = BOOK_AUTHOR.AUTHOR_ID;

SELECT LOAN_ID, BRANCH_NUM, MEMBER_NUM, BOOK_ID, DATE_ISSUED, LIBRARIAN_OUT, DATE_DUE, DATE_RETURNED, LIBRARIAN_IN, FINE_AMOUNT
FROM LOAN_HISTORY
WHERE FINE_AMOUNT > 0;

SELECT MEMBER_NUM, LAST_NAME, FIRST_NAME
FROM MEMBERS
ORDER BY LAST_NAME DESC, FIRST_NAME;

SELECT MEMBER_NUM, LAST_NAME, FIRST_NAME
FROM MEMBERS
WHERE MEMBER_NUM IN
(SELECT MEMBER_NUM
FROM LOAN_HISTORY
WHERE LIBRARIAN_OUT = 1);

SELECT BRANCH_NUM, SUM(ON_HAND)
FROM INVENTOTY
GROUP BY BRANCH_NUM;

Create a free my code stock.com account now.

my code stok.com is a free service, which allows you to save and manage code snippes of any kind and programming language. We provide many advantages for your daily work with code-snippets, also for your teamwork. Give it a try!

Find out more and register now

You can customize the height of iFrame-Codes as needed! You can find more infos in our API Reference for iframe Embeds.