Skip to content

Instantly share code, notes, and snippets.

@onegrx

onegrx/12novJOIN.sql

Created November 12, 2015 12:43
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save onegrx/8f580b1f38c325ffb186 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save onegrx/8f580b1f38c325ffb186 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
12novJOIN.sql
use library
select fine_paid, in_date, member_no, datediff(day, due_date, in_date) as time_delay
from title inner join loanhist on title.title_no = loanhist.title_no
where title = 'Tao Teh King' and in_date > due_date
select isbn
from reservation inner join member on reservation.member_no = member.member_no
where firstname = 'Stephen' and middleinitial = 'A' and lastname = 'Graff'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment