• Home
  • Free Trial
  • Sign In
  • Plans
  • Tracks
  • Library
  • Community
  • Support
  • Jobs
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • 21st Century Skills
      • • Android
      • • APIs
      • • Business
      • • C#
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Equity, Diversity, and Inclusion (EDI)
      • • Go
      • • HTML
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • PHP
      • • Python
      • • Quality Assurance
      • • Ruby
      • • Security
  • Miroslav Pasajlic
    Miroslav Pasajlic
    795 Points

    The columns you selected were named Home Team, Home Score, Away team, Away Score, Date Played and not 'Home Team', 'Home

    Posted December 20, 2022 2:36pm by Miroslav Pasajlic
    Miroslav Pasajlic
    795 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    1 Answer

  • K. Brice Perez
    K. Brice Perez
    15,095 Points

    How do I write an as function to retrieve the product name and product description

    Posted March 3, 2022 5:48pm by K. Brice Perez
    K. Brice Perez
    15,095 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    2 Answers

  • Anne Olaribigbe
    Anne Olaribigbe
    154 Points

    My code is not working Here is the code

    Posted November 7, 2021 7:43pm by Anne Olaribigbe
    Anne Olaribigbe
    154 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    1 Answer

  • Steven Crutchfield
    Steven Crutchfield
    311 Points

    Syntax on SQL Alias error

    Posted June 27, 2021 2:26pm by Steven Crutchfield
    Steven Crutchfield
    311 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    2 Answers

  • cgeorge
    cgeorge
    5,492 Points

    Bummer: Did you select from the `users` table?

    Posted January 11, 2021 1:22am by cgeorge
    cgeorge
    5,492 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    1 Answer

  • Aravind Rangaswamy
    Aravind Rangaswamy
    2,035 Points

    this sports team database there's a results table with the columns of id, home_team, home_score, away_team, away_score

    Posted September 8, 2020 8:29am by Aravind Rangaswamy
    Aravind Rangaswamy
    2,035 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    1 Answer

  • Usha Rani
    Usha Rani
    107 Points

    using as and special character " " but not getting correct query

    Posted August 28, 2020 8:56pm by Usha Rani
    Usha Rani
    107 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    1 Answer

  • Blake Miller
    Blake Miller
    247 Points

    I think there is a bug not letting me move on. I believe this query is correct.

    Posted April 26, 2020 9:20pm by Blake Miller
    Blake Miller
    247 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    1 Answer

  • Abu-al Fahad
    PLUS
    Abu-al Fahad
    Courses Plus Student 719 Points

    whatis the correct answer

    Posted January 23, 2020 10:47am by Abu-al Fahad
    Abu-al Fahad
    Courses Plus Student 719 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    0 Answers

  • vona goodpaster
    vona goodpaster
    1,719 Points

    I am no sure why my code is incorrect for challenge task 3 of 4.

    Posted January 2, 2020 7:10pm by vona goodpaster
    vona goodpaster
    1,719 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    4 Answers

  • DCI Seven
    DCI Seven
    828 Points

    SELECT name AS "Product Name", description AS "Product Description", FROM products; whats wrong with this Query

    Posted December 3, 2019 8:13pm by DCI Seven
    DCI Seven
    828 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    1 Answer

  • DCI Seven
    DCI Seven
    828 Points

    SELECT name AS "Product Name", description AS "Product Description" FROM products;

    Posted December 3, 2019 7:28pm by DCI Seven
    DCI Seven
    828 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    2 Answers

  • Hien Ha
    Hien Ha
    1,417 Points

    What wrong with my code

    Posted November 19, 2019 10:27pm by Hien Ha
    Hien Ha
    1,417 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    1 Answer

  • Victor Melvin
    Victor Melvin
    1,679 Points

    What is wrong with my syntax on this AS output Query ?

    Posted November 18, 2019 7:27pm by Victor Melvin
    Victor Melvin
    1,679 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    1 Answer

  • terri ray
    terri ray
    870 Points

    I am not sure what I did wrong: select id as "Username",first_name as "First Name",last_name as "Last Name" from users;

    Posted November 11, 2019 11:51am by terri ray
    terri ray
    870 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    1 Answer

  • shiny peanut
    shiny peanut
    5,113 Points

    AS Keyword in SQL

    Posted August 18, 2019 4:02pm by shiny peanut
    shiny peanut
    5,113 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    3 Answers

  • Dilan Patel
    Dilan Patel
    2,863 Points

    I cannot seem to figure out where I went wrong?

    Posted June 20, 2019 11:05am by Dilan Patel
    Dilan Patel
    2,863 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    1 Answer

  • brayden gosse
    brayden gosse
    2,226 Points

    In this sports team database there's a results table with the columns of id, home_team, home_score, away_team, away_scor

    Posted May 7, 2019 11:55pm by brayden gosse
    brayden gosse
    2,226 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    0 Answers

  • Aaron Howarth
    Aaron Howarth
    169 Points

    What am I missing here with my syntax?

    Posted April 10, 2019 6:53pm by Aaron Howarth
    Aaron Howarth
    169 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    1 Answer

  • Elise Glynn
    Elise Glynn
    529 Points

    Why and when would we need to use aliases?

    Posted April 2, 2019 3:36pm by Elise Glynn
    Elise Glynn
    529 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    1 Answer

  • Marcelo Campos
    Marcelo Campos
    176 Points

    How can I build the SQL challenge ?

    Posted November 13, 2018 8:08pm by Marcelo Campos
    Marcelo Campos
    176 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    2 Answers

  • Salem Osi
    Salem Osi
    1,928 Points

    SQL basics help/Categorizing with AS

    Posted September 5, 2018 2:37am by Salem Osi
    Salem Osi
    1,928 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    1 Answer

  • Fairooz Adams
    Fairooz Adams
    2,704 Points

    Did you ever hear the tragedy of Darth Plagueis The Wise? I thought not. It's not a story the Jedi would tell you. It's

    Posted September 4, 2018 3:18pm by Fairooz Adams
    Fairooz Adams
    2,704 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    1 Answer

  • Erin Clayton
    Erin Clayton
    3,840 Points

    What's wrong with this code? Looks good to me?

    Posted August 18, 2018 1:47pm by Erin Clayton
    Erin Clayton
    3,840 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    2 Answers

  • Lanie Haynes
    Lanie Haynes
    2,691 Points

    I am not sure what is off about my syntax here

    Posted August 17, 2018 7:23pm by Lanie Haynes
    Lanie Haynes
    2,691 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    1 Answer

  • Elia Malmsten
    Elia Malmsten
    5,953 Points

    I can't find the error in my code

    Posted July 10, 2018 5:11pm by Elia Malmsten
    Elia Malmsten
    5,953 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    1 Answer

  • Luis Ponce
    Luis Ponce
    2,290 Points

    What is wrong with the folllowing query? SELECT name AS Product Name,description AS Product Description, FROM products;

    Posted June 25, 2018 4:21pm by Luis Ponce
    Luis Ponce
    2,290 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    3 Answers

  • Hatem Zreek
    Hatem Zreek
    7,739 Points

    Mistake in the Challenge!!!

    Posted May 8, 2018 1:23am by Hatem Zreek
    Hatem Zreek
    7,739 Points
    • Databases
    • SQL Basics
    • Getting Data from a Database
    • Categorizing Your Output with 'AS'

    1 Answer

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.

    Treehouse

  • About
  • Blog
  • Careers
  • Community
  • Stories
  • Shop
  • Contact
  • Gift Card

See Full Catalogue

Techdegree

  • Front End Web Development
  • Full Stack JavaScript
  • Python Development
  • Data Analysis
  • UX Design

Tracks

  • Learn to Code for Beginners
  • Beginning Python
  • Beginning SQL
  • Beginning Java
  • ...see more

Courses

  • JavaScript Basics
  • Intro to HTML & CSS
  • Python Basics
  • CSS Layout
  • ...see more

Explore

  • Plans
  • Perks
  • Public Library Access
  • Treehouse for Libraries
  • Treehouse for Businesses
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
Terms & Conditions | Privacy

© 2023 Treehouse Island, Inc.