나는 이렇게 학습한다/Algorithm & SQL

SQL Grasshopper: Select Columns

daco2020 2022. 6. 5. 01:28
반응형

#Greetings Grasshopper!# Using only SQL, write a query that returns all rows in the custid, custname, and custstate columns from the customers table.


###Table Description for customers:###

ColumnData TypeSizeSample

custid integer 8 4
custname string 50 Anakin Skywalker
custstate string 50 Tatooine
custard string 50 R2-D2

 

 

Solution:

SELECT 
  custid, custname, custstate 
FROM
  customers

 

반응형