SQLite Forum

trying to select one column from one table
Login
I imported data from CSV:

nicholas@mordor:~/powershell$ 
nicholas@mordor:~/powershell$ sqlite3 med
SQLite version 3.31.1 2020-01-27 19:55:54
Enter ".help" for usage hints.
sqlite> 
sqlite> .schema
CREATE TABLE lab(
  "Date"",""Region"",""New_Tests"",""Total_Tests"",""Positivity"",""Turn_Around" TEXT
);
sqlite> 
sqlite> select * from lab limit 3;
2020-01-23,"BC",2,2,0,32
2020-01-23,"Fraser",0,0,0,0
2020-01-23,"Interior",0,0,0,0
sqlite> 
sqlite> select "Date" from lab limit 3;
Date
Date
Date
sqlite> 
sqlite> select "Region" from lab limit 3;
Region
Region
Region
sqlite> 


perhaps there's some problem with how it was imported?  But it seems to "be" in the database fine.

How do I query just a single column, such as "Region", from above.