THE CLOUD EXPEDITION! · Chapter 4
Stock the Pond
Marina swims up with an armload of data scrolls. An empty database is like an empty pond — no fun at all! She winks. Lucky for you, my lakes species data is publicly shared. Lets copy it into YOUR database and make it your own. Learn to Populate a Database — copying data from a public share into your own cloud database.
Your task
Copy Marina Lake's species data into your own database, then verify the results. First create a table in your database using <code>CREATE OR REPLACE TABLE ... AS SELECT</code>, then query the top 5 species by population. Run both statements together.<br><br><b>Re-attach if needed:</b><ul><li><code>dbquacks_marina_lake</code> → <code>md:_share/marina_lake_db/3be07852-dfce-4b29-b415-99c9f7fdcc6a</code></li></ul>