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

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