SQL Grasshopper: Select Columns

#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