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

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 using SELECT. my attempt is under the comment but i think it is incorrect. i am not sure how to do it. the last two images are the tables we need info from. thank you for any help !
 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 using SELECT. my attempt is under the comment but i

/*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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!