This community-built FAQ covers the “Introduction” exercise from the lesson “Aggregate Functions”.
Paths and Courses
This exercise can be found in the following Codecademy content:
Web Development
Data Science
Learn SQL
FAQs on the exercise Introduction
Join the Discussion. Help a fellow learner on their journey.
Ask or answer a question about this exercise by clicking reply (
) below!
Agree with a comment or answer? Like (
) to up-vote the contribution!
Need broader help or resources? Head here.
Looking for motivation to keep learning? Join our wider discussions.
Learn more about how to use this guide.
Found a bug? Report it!
Have a question about your account or billing? Reach out to our customer support team!
None of the above? Find out where to ask other questions here!
Why are both the database schema for the fake_apps table and the startups table displayed in the side pane, when I did a select statement only from fake_apps?
1 Like
Got more useful data out of SELECT SCHEMA();
That query returns what was asked, Table Columns, and very little else.
The supposed “correct” answer billboards the output pane leaving the schema many many scrolls down.
Sure, sure, one can pull the column names from the first line of output, but why all the excess data?
My method returns what we are looking for and nothing else.
Or are we not supposed to know about built-in functions yet? I’ve done little more than dabble in SQL for awhile now, still, that’s the first command I use whenever I come in possession of a new database. How is it structured. Look at the schema. You get the columns and the data type for each.
1 Like
i would assume that with SELECT *, all the Database Schema of each table contained in the database is displayed.
