The Examples Book
Appendices
Corporate Partners DEAF PODS National Data Mine Network Personal Professional Development Programming Languages Projects REEU Registration Seminar TA Training Starter Guides Template Module The Data Mine Workshops The Examples Book Think Summer University Partners

Programming Languages

    • Coding Languages
    • Perl
      • Perl Books
    • Python
      • Indentation
      • Variables
      • Printing and F-Strings
      • Logical Operators
      • Tuples
      • Lists
      • Dictionaries
      • Sets
      • Dates and Times
      • Control Flow
      • Writing Functions
      • Classes
      • Writing Scripts
        • argparse
      • pandas
        • Reading & Writing Data
        • Series
        • DataFrames
        • Indexing
        • Dates and Times
        • Aggregate Functions
        • Reshaping
      • Pathlib
      • Scraping
        • Requests
        • BeautifulSoup
        • lxml
        • Selenium
        • Running on Anvil
      • Plotting
        • Matplotlib
        • Plotly
      • PyTorch
      • Documentation
        • Docstrings & Comments
        • pdoc
        • Sphinx
      • Testing
        • unittest
        • pytest
        • doctest
        • mypy
      • Serialization & Deserialization
        • MessagePack
      • Dask
      • JAX
      • Package Management
        • Package Management Fundametals
        • PyPi
        • Pip
        • Virtualenv
        • Pipenv
        • Poetry
        • Anaconda
      • Python Coding Examples (Coding Bat)
      • Python Official Documentation
    • R
      • Variables
      • Logical Operators
      • Lists and Vectors
      • data.frames
      • Reading and Writing Data
      • Control Flow
      • Writing Functions
      • R Base Functions
        • ncol
        • nrow
        • dim
        • str
        • head
        • tail
        • unique
        • mean
        • median
        • var
        • sd
        • abs
        • sum
        • min
        • max
        • length
        • table & prop.table
        • rep
        • seq
        • which
        • grep
        • sort
        • order
        • paste & paste0
        • cut
        • split
        • subset
        • merge
      • Apply Functions
      • Plotting
        • R graphics plotting
          • barplot
        • ggplot2
          • geom_point
      • Tidyverse
        • Piping
        • select
        • transmute
        • mutate
        • case_when
        • between
        • glimpse
        • filter
        • arrange
        • group_by
        • summarize
        • str_extract and str_extract_all
        • lubridate
        • strrep
        • nchar
      • data.table
      • SQL in R
      • Scraping
      • Shiny
      • R Bloggers - Resource for Variety of R Topics
    • SQL
      • SQL books
      • Terminology
      • Queries
        • SQL Baseball examples
        • SQL Chinook examples
        • SQL examples from the STAT-LLC
      • Aliasing
      • Aggregate functions
      • Joins
  • Corporate Partners
    • stable
  • DEAF PODS
    • stable
  • National Data Mine Network
    • stable
  • Personal
    • stable
  • Professional Development
    • stable
  • Programming Languages
    • stable
  • Projects
    • stable
  • REEU
    • stable
  • Registration
    • stable
  • Seminar TA Training
    • stable
  • Starter Guides
    • stable
  • Template Module
    • stable
  • The Data Mine Workshops
    • stable
  • The Examples Book
    • stable
  • Think Summer
    • stable
  • University Partners
    • stable
Programming Languages stable
  • Programming Languages
  • SQL
  • Queries
  • SQL examples from the STAT-LLC
Edit this Page

STAT-LLC SQL examples

SQL Chinook examples Aliasing

Purdue University, The Data Mine, Hillenbrand Hall, 1301 Third Street, West Lafayette, IN 47906-4206, (765) 494-0325

© 2020 Purdue University | An equal access/equal opportunity university | Integrity Statement | Copyright Complaints | Maintained by The Data Mine

Contact The Data Mine at datamine@purdue.edu for accessibility issues with this page | Accessibility Resources