Greetings, SQL lovers!
I am writing to you today because I need your help.
SQLtest.online is a free platform designed to help people of all levels master SQL.How you can help:
The more people use the platform, the better it will become. We'll be able to add more content, improve features, and create a better community for SQL enthusiasts.
Thanks for your help!
Command SQLtest.online
Find all records in the penguins table about penguins with body weight less than the average for their species and sex.
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.ident | name | building |
---|---|---|
gen | Genetics | Chesson |
species | island | bill_length_mm | bill_depth_mm | flipper_length_mm | body_mass_g | sex |
---|---|---|---|---|---|---|
Gentoo | Biscoe | 52.1 | 17 | 230 | 5550 | MALE |
species | island | bill_length_mm | bill_depth_mm | flipper_length_mm | body_mass_g | sex |
---|---|---|---|---|---|---|
Gentoo | Biscoe | 52.1 | 17 | 230 | 5550 | MALE |
ident | personal | family | dept | age |
---|---|---|---|---|
7 | Abram | Chokshi | gen | 23 |
ident | name | details |
---|---|---|
1 | WY401 | {"acquired": "2023-05-01"} |
2 | Inphormex | {"acquired": "2021-07-15", "refurbished": "2023-10-22"} |
3 | AutoPlate 9000 | {"note": "needs software update"} |