The Examples Book
Appendices
Corporate Partners National Data Mine Network Personal Programming Languages Projects Registration Seminar TA Starter Guides Template Module The Data Mine Workshops The Examples Book Tools

Programming Languages

    • Coding Languages
    • Perl
      • Perl Books
    • Python
      • Python Starter Skills Roadmap
      • 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
  • National Data Mine Network
    • stable
  • Personal
    • stable
  • Programming Languages
    • stable
  • Projects
    • stable
  • Registration
    • stable
  • Seminar TA
    • stable
  • Starter Guides
    • stable
  • Template Module
    • stable
  • The Data Mine Workshops
    • stable
  • The Examples Book
    • stable
  • Tools
    • 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

© 2024 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