human_organs.sql

human_organs.sql

/* 
Top 10 organs in the human body, by weight
Adapted from: https://propelsteps.wordpress.com/2014/10/12/know-top-10-largest-organs-of-the-human-body/ 
Collected by: https://www.khanacademy.org/profile/errorbuddy/
*/

CREATE TABLE organs (id INTEGER PRIMARY KEY,
    name TEXT,
    weight INTEGER,
    important_functions TEXT,
    gender TEXT DEFAULT "both");
    
INSERT into organs (name, weight, important_functions) VALUES("Skin", 24.0, "Protects internal organs.");
INSERT into organs (name, weight, important_functions) VALUES("Liver", 3.4 , "Delivers blood to cells.");
INSERT into organs (name, weight, important_functions) VALUES("Brain", 2.8 , "Governs the body's actions.");
INSERT into organs (name, weight, important_functions) VALUES("Lungs", 2.4 , "Brings in oxygen and expels carbon dioxide.");
INSERT into organs (name, weight, important_functions) VALUES("Heart", 0.6, "Pumps blood, which carries nutrients, to the rest of the body.");
INSERT into organs (name, weight, important_functions) VALUES("Kidneys", 0.6, "Removes the waste products from blood.");
INSERT into organs (name, weight, important_functions) VALUES("Spleen", 0.4, "Produces the pulp of red and white blood cells.");
INSERT into organs (name, weight, important_functions) VALUES("Pancreas", 0.2, "Produces insulin, glucagon, and somatostatin hormones.");
INSERT into organs (name, weight, important_functions) VALUES("Thyroid", 0.1, "Produces thyroxine and triiodothyronine hormones.");
INSERT into organs (name, weight, important_functions, gender) VALUES("Prostate", 0.04, "Secretes fluid which protects and nourishes sperm.", "male");