[solved]-Vtanimals 8 Anid Antype Vtanimaltypes Antype Anname Vtclients Clid Clnamelast Clnamefirst Q39011256
DATA STRUCTURE:
WRITE COMMAND FOR TASKS USING MYSQL.
vt_animals 8 an_id an_type vt_animal_types an_type an_name vt_clients cl_id cl_name_last cl_name_first cl_address cl_city cl_state cl_postal_code cl_phone an_dob d_id vt_staff 8 stf_id stf_name_last stf_name_first stf_job_title vt_exam headers 2 ex_id an_id stf_id ex_date 00 vt_exam details ex_id line_item srv_id ex_fee ex_desc vt_staff_pay stf_id stf_ssn stf_salary stf hire date vt_services srv_id srv_list_price srv_desc srv_type Task 05: Display the exam id, the service id, and the fee charged for each service performed on an exam. Order by the exam id and then by the fee. Task 06: Display the animal name and animal type and animal date of birth values from the animals table. Suppress any duplicates. Sort the display in order by the type as the first sort key and the name as the second sort key. Task 07: For each exam, display the animal id, the exam date and the id of the staff person who did the exam. Display the rows in order by the staff id; use the exam date as the second sort key with the earlier exams first. Use the data in the exam headers table. Task 08: The vet wants a list of the different locations for the clients. For this task, the term location refers to the city and state. The display will include the client state in the first column and city in the second column and will not include duplicate rows. Sort the result set by state and city. Show transcribed image text vt_animals 8 an_id an_type vt_animal_types an_type an_name vt_clients cl_id cl_name_last cl_name_first cl_address cl_city cl_state cl_postal_code cl_phone an_dob d_id vt_staff 8 stf_id stf_name_last stf_name_first stf_job_title vt_exam headers 2 ex_id an_id stf_id ex_date 00 vt_exam details ex_id line_item srv_id ex_fee ex_desc vt_staff_pay stf_id stf_ssn stf_salary stf hire date vt_services srv_id srv_list_price srv_desc srv_type
Task 05: Display the exam id, the service id, and the fee charged for each service performed on an exam. Order by the exam id and then by the fee. Task 06: Display the animal name and animal type and animal date of birth values from the animals table. Suppress any duplicates. Sort the display in order by the type as the first sort key and the name as the second sort key. Task 07: For each exam, display the animal id, the exam date and the id of the staff person who did the exam. Display the rows in order by the staff id; use the exam date as the second sort key with the earlier exams first. Use the data in the exam headers table. Task 08: The vet wants a list of the different locations for the clients. For this task, the term location refers to the city and state. The display will include the client state in the first column and city in the second column and will not include duplicate rows. Sort the result set by state and city.
Expert Answer
Answer to vt_animals 8 an_id an_type vt_animal_types an_type an_name vt_clients cl_id cl_name_last cl_name_first cl_address cl_cit… . . .
OR
