Challenge
No
Use your wombat database, with the records you downloaded.
You'll be given some questions to write SELECTs for. Make a webpage with the query number, question, SQL, a screenshot of the results. Put your name at the top. You can see an example of what it should look like.
- What are the ids and names of wombats with weights less than 25 kilos?
- What's the weight of wombats named Zora?
- What's the weight of wombats named either Zora, or Hawthorne?
- How many wombats weigh less than 30 kilos?
- What are the ids and names of wombats with ids less than 5, or weights more than 40 kilos?
- How many wombats have missing weight data?
- How many wombats have missing data for weights and comments?
- How many wombats with missing comments have ids less than 10?
Submit the URL of your page.
If you were logged in as a student, you could submit a solution to this exercise.
Where referenced