Hi @css2389480521, welcome to the forums!
This is actually not a basic question as far as SQL is involved. It is actually not covered in the Codecademy curriculum.
If you are using SQLite, you can use PRAGMA functions to find this info. See here for documentation.
To find the number of columns for a table (let’s call this table
tracks) you would use this query:
If you want to find the names of the columns that contains strings, you would use this query:
WHERE type LIKE 'NVARCHAR%';
From there you can just
SELECT those columns
FROM tracks if you want.
As far as selecting only the columns that contain strings within your main
SELECT statement (filtering by type), I suggest looking on Google and doing some research if it is important to you, as that is what I would have to do to answer your question.
Hope this helps. Happy coding!