Question: The green comments in the first image is the problem. i have to write in sql for it to do the following in the comments



/*From the specialist table, retrieve the first name, last name and contact number for the *people that provided care to penguins from the species tablet/ SELECT specialist_fname, specialist_lname, specialist_contact, species_order FROM tbl_specialist, tbl_species Where species_order= (CONVERT(50) penguin); INSERT INTO tbl specialist (specialist_fname, specialist_iname, specialist_contact) VALUES ('margret', 'nguyen', '345-222-3134'), ('mary','fishcer', '433-221-2466'), ('arnold', 'holden', '737-223-1246'), ('ken', 'byeson', '628-288-7939'), ('delmonte','fye', '638-278-2820) : INSERT INTO tbl_species (species_name, species_animalia, species_class, species_order, species_habitat, species_nutrition, species_care) VALUES (brown bear', 1, 102, 3, 5007, 2200, 'care_1'), ('jaguar', 1, 102, 1, 5007, 2200, 'care_4"), ('penguin', 1, 100, 1, 5003, 2200, 'care_6'), ('ghost bat', 1, 102, 1, 5007, 2204, 'care_2'), ('chicken', 1, 100, 3, 5001, 2205, 'care_0'), ('panda', 1, 102, 3, 5006, 2202, 'care_4'), ('bobcat', 1, 102, 1, 5001, 2200, "care_5'), ('grey wolf', 1, 102, 1, 5000, 2201, 'care_4")
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
