Basic SQL Topics
SQL can be very simple
There’s many ways to write a SQL statement, but the majority will have 3 key features:
SELECT…
FROM…
WHERE…
Consider the Wikipedia article to the right with the world’s most spoken languages as our database.
What if we only wanted the languages with above 550 million speakers? (So the top 4 rows) Here’s how that SQL query would look:
SELECT *
FROM database_table
WHERE Total Speakers > 550,000,000
