They are asking me to write a query that display the following table:
- Select each table as a string
- Select the number of attributes as an integer (count the number of attributes per table).
- Select the number of rows using the COUNT(*) function
- Use the compound-operator UNION ALL to bind these rows together.
How do I do that?
I knew that for getting the name of each table I have to use
SELECT name AS table_name FROM sqlite_schema WHERE type = 'table'
but the rest is a mistery to me. Would you help me?