[solved]-Vtanimals 8 Anid Antype Vtanimaltypes Antype Anname Vtclients Clid Clnamelast Clnamefirst Q39011218
DATA BASE STRUCTURE:
TASKS (WRITE IN SQL; RUN 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 01: For each row in the staff table, display the first name and last name of each staff person and their job title. Task 02: Display the animal id with a column alias of “ID”, the animal name with a column alias of “Name”, the animal type with the column alias “Animal Type”, and the birth date with a column alias of “BirthDate” for each animal. Display the data with the oldest animals first. Task 03: The vet wants to see a list of the different types of animals we currently have registered with the clinic. Display the animal types from the animals table. Suppress any duplicates. Task 04: For each row in the services table, display the service type and description. The rows should be sorted by the service type and list price. 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 01: For each row in the staff table, display the first name and last name of each staff person and their job title. Task 02: Display the animal id with a column alias of “ID”, the animal name with a column alias of “Name”, the animal type with the column alias “Animal Type”, and the birth date with a column alias of “BirthDate” for each animal. Display the data with the oldest animals first. Task 03: The vet wants to see a list of the different types of animals we currently have registered with the clinic. Display the animal types from the animals table. Suppress any duplicates. Task 04: For each row in the services table, display the service type and description. The rows should be sorted by the service type and list price.
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
