Skip to content
Navigation Menu
Toggle navigation
Sign in
Appearance settings
Platform
AI CODE CREATION
GitHub Copilot
Write better code with AI
GitHub Copilot app
Direct agents from issue to merge
MCP Registry
New
Integrate external tools
DEVELOPER WORKFLOWS
Actions
Automate any workflow
Codespaces
Instant dev environments
Issues
Plan and track work
Code Review
Manage code changes
APPLICATION SECURITY
GitHub Advanced Security
Find and fix vulnerabilities
Code security
Secure your code as you build
Secret protection
Stop leaks before they start
EXPLORE
Why GitHub
Documentation
Blog
Changelog
Marketplace
View all features
Solutions
BY COMPANY SIZE
Enterprises
Small and medium teams
Startups
Nonprofits
BY USE CASE
App Modernization
DevSecOps
DevOps
CI/CD
View all use cases
BY INDUSTRY
Healthcare
Financial services
Manufacturing
Government
View all industries
View all solutions
Resources
EXPLORE BY TOPIC
AI
Software Development
DevOps
Security
View all topics
EXPLORE BY TYPE
Customer stories
Events & webinars
Ebooks & reports
Business insights
GitHub Skills
SUPPORT & SERVICES
Documentation
Customer support
Community forum
Trust center
Partners
View all resources
Open Source
COMMUNITY
GitHub Sponsors
Fund open source developers
PROGRAMS
Security Lab
Maintainer Community
Accelerator
GitHub Stars
Archive Program
REPOSITORIES
Topics
Trending
Collections
Enterprise
ENTERPRISE SOLUTIONS
Enterprise platform
AI-powered developer platform
AVAILABLE ADD-ONS
GitHub Advanced Security
Enterprise-grade security features
Copilot for Business
Enterprise-grade AI features
Premium Support
Enterprise-grade 24/7 support
Pricing
Search or jump to...
Search code, repositories, users, issues, pull requests...
Search syntax tips
Provide feedback
Saved searches
Use saved searches to filter your results more quickly
Sign in
Sign up
Appearance settings
Resetting focus
You signed in with another tab or window.
Reload
to refresh your session.
You signed out in another tab or window.
Reload
to refresh your session.
You switched accounts on another tab or window.
Reload
to refresh your session.
Dismiss alert
{{ message }}
jmgold
/
SQL-Queries
Public
Notifications
You must be signed in to change notification settings
Fork
7
Star
30
Code
Issues
0
Pull requests
0
Actions
Projects
Wiki
Security and quality
0
Insights
Additional navigation options
Code
Issues
Pull requests
Actions
Projects
Wiki
Security and quality
Insights
Files
Expand file tree
master
Breadcrumbs
SQL-Queries
/
Testing
/
Copy path
Directory actions
More options
More options
Directory actions
More options
More options
Latest commit
History
History
History
master
Breadcrumbs
SQL-Queries
/
Testing
/
Copy path
Top
Folders and files
Name
Name
Last commit message
Last commit date
parent directory
..
Items in Limbo.sql
Items in Limbo.sql
Paging list.sql
Paging list.sql
abandoned hold ratio.sql
abandoned hold ratio.sql
address cleanup.sql
address cleanup.sql
address sanitization testing.sql
address sanitization testing.sql
animated popular titles.sql
animated popular titles.sql
aspen update checker.sql
aspen update checker.sql
bad registrations.sql
bad registrations.sql
call number range take 3.sql
call number range take 3.sql
call number range take 4.sql
call number range take 4.sql
call number range take 5.sql
call number range take 5.sql
chatgpt common call number prefixes.sql
chatgpt common call number prefixes.sql
chatgpt forecast calculation.sql
chatgpt forecast calculation.sql
checkin error cleanup script.sql
checkin error cleanup script.sql
checkout by scat and geogaphy.sql
checkout by scat and geogaphy.sql
checkout location by census tract.sql
checkout location by census tract.sql
checkout value.sql
checkout value.sql
code usage.sql
code usage.sql
collection dev by call number.sql
collection dev by call number.sql
collection dev by diversity.sql
collection dev by diversity.sql
comcat holds.sql
comcat holds.sql
data studio choropleth map by tract.sql
data studio choropleth map by tract.sql
data studio choropleth map.sql
data studio choropleth map.sql
dei comp list test.sql
dei comp list test.sql
dei database upload.sql
dei database upload.sql
dei subtopic.sql
dei subtopic.sql
diversity audit list based.sql
diversity audit list based.sql
diversity audit v2.sql
diversity audit v2.sql
diversity audit.sql
diversity audit.sql
duplicate holds on merged bibs.sql
duplicate holds on merged bibs.sql
exp patrons.sql
exp patrons.sql
expiring patrons restart march 22.sql
expiring patrons restart march 22.sql
find malformed census fields.sql
find malformed census fields.sql
fines paid expanded.sql
fines paid expanded.sql
fines snapshot.sql
fines snapshot.sql
geocoder block errors.sql
geocoder block errors.sql
geocoder tester.sql
geocoder tester.sql
hillbilly holds.sql
hillbilly holds.sql
hold removed testing.sql
hold removed testing.sql
holds export.sql
holds export.sql
holds placed animation.sql
holds placed animation.sql
in_transit_snapshot_map.sql
in_transit_snapshot_map.sql
json circ_status experiment.sql
json circ_status experiment.sql
lda subject grouping.sql
lda subject grouping.sql
lex purchase alert.sql
lex purchase alert.sql
library comparison.sql
library comparison.sql
lost book fines.sql
lost book fines.sql
missing 008 fields.sql
missing 008 fields.sql
monthly patron engagement.sql
monthly patron engagement.sql
network transfer by geoid.sql
network transfer by geoid.sql
network transfer by owning library and geoid.sql
network transfer by owning library and geoid.sql
non local holds.sql
non local holds.sql
old item level holds.sql
old item level holds.sql
online patron update.sql
online patron update.sql
order record purge.sql
order record purge.sql
patron anniversary message.sql
patron anniversary message.sql
patrons by geography all.sql
patrons by geography all.sql
patrons by geography overdue variant.sql
patrons by geography overdue variant.sql
patrons by tract for bg.sql
patrons by tract for bg.sql
possible duplicate registrations.sql
possible duplicate registrations.sql
ptype by library -for libraryiq testing.sql
ptype by library -for libraryiq testing.sql
purchase alert update.sql
purchase alert update.sql
purchase alert with isbn.sql
purchase alert with isbn.sql
received titles on street date.sql
received titles on street date.sql
savannah circ.sql
savannah circ.sql
savannah patron.sql
savannah patron.sql
scat subject keyword frequency by varfield.sql
scat subject keyword frequency by varfield.sql
scat subject keyword frequency.sql
scat subject keyword frequency.sql
sent order errors update.sql
sent order errors update.sql
split address fields.sql
split address fields.sql
sql import list test.sql
sql import list test.sql
starburst vis test.sql
starburst vis test.sql
subject table.sql
subject table.sql
subject usage.sql
subject usage.sql
supply and demand.sql
supply and demand.sql
text search practice.sql
text search practice.sql
titles in multiple collections.sql
titles in multiple collections.sql
tract identifier.sql
tract identifier.sql
unbalanced holds.sql
unbalanced holds.sql
unfilled holds errors.sql
unfilled holds errors.sql
unowned report troubleshooting.sql
unowned report troubleshooting.sql
wob duplicate barcodes.sql
wob duplicate barcodes.sql
View all files
You can’t perform that action at this time.