Dear user,
You and many others enjoy this site for free. Our only sources of funding are advertising and donations. To help us keep this project free for everyone, please consider not blocking ads on the site.
If ads are an issue for you, please let me know, and I'll turn them off for your account.
Based on the penguins table, create a penguins_islands_view view with the fields island - the name of the island and penguins_count - the number of penguins living on it.
Use SQLite syntax to write your answer. Descriptions of tables are provided in the right pane.
Write your request in the field below and click the "Check it!" button.
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Explore over 320 diverse tasks on our platform.
Querynomicon (SQLite)
A compact database for learning the basics of SQL.
The Querynomicon database contains tables:
little_penguins - table of little penguins.
- speciesPenguin species.
- islandIsland of residence.
- bill_length_mmBill length, mm.
- bill_depth_mmBill depth, mm.
- flipper_length_mmFlipper length, mm.
- body_mass_gBody mass, g.
- sexSex.
species |
island |
bill_length_mm |
bill_depth_mm |
flipper_length_mm |
body_mass_g |
sex |
Gentoo |
Biscoe |
52.1 |
17 |
230 |
5550 |
MALE |
penguins - table of penguins.
- speciesPenguin species.
- islandIsland of residence.
- bill_length_mmBill length, mm.
- bill_depth_mmBill depth, mm.
- flipper_length_mmFlipper length, mm.
- body_mass_gBody mass, g.
- sexSex.
species |
island |
bill_length_mm |
bill_depth_mm |
flipper_length_mm |
body_mass_g |
sex |
Gentoo |
Biscoe |
52.1 |
17 |
230 |
5550 |
MALE |
staff - table of employees.
- identEmployee number.
- personalEmployee first name.
- familyEmployee last name.
- deptDepartment.
- ageAge.
ident |
personal |
family |
dept |
age |
7 |
Abram |
Chokshi |
gen |
23 |