need sql coder now urgent

-- 1. List details for the vets that charged an amount less than the specialty rate for that attending vet in an appointment in 2016 -- 2. List for each vet by vet id the total amount they have billed for visits in 2016. However only show the results if the total exceeded $2500 -- 3. List the owner details for "Dog" type patients who are of either the "Dolberman" or "Pit Bull" breed. Show each owner only once -- 4. List the id, name and type for every Patient that attended visits in March 2016. Show each Patient only once. Sequence by name within type -- 5. List the details for the owners that have had visits in 2016. Only show each owner once and sequence by owner name -- 6. List the details for all the visits attended by the vet "Joe" in 2016. Sequence the visits by date (most recent last) -- 7. List the youngest date of birth for a patient that is a "Cat" type of the "Persian" breed -- 8. Show the count of the total number of visits attended by the vet Joe in 2016 -- 9. List the details of any patients that have been seen in 2016. Show patient details only once. Sequence by patient name within type within breed -- 10. Show the count for the number of different type of pets as seen by the vet "Joe" in 2016 -- 11. List details for the owners that have "dog" type pets of the "Dolberman" breed. Show each owner only once and sequence alphabetically by owner name -- 12. List the patient id for any patient whose maximum bill for a visit was more than $500 in 2016 -- 13. Show a count of the number of patients by breed. Order the output by highest count to lowest -- 14. List owner id for the owners that have more than 2 dogs -- 15. List in alphabetic sequence by name, details for the vets that have "Dog" as a specialty. --16. List the owner details for those owners who own dogs and or cats and whose address also contains either the characters ‘Mark’ or ‘Scar’ --17. Show the total amount billed for each patient that was seen in 2016 and who had at least 3 visits in that year --18. List the details for owners that have had patients seen at visits with the vet named Joe. Only show each owner once and sequence by owner name --19. List the details for vets that do not have a dog specialty but have still attended a visit for either a Doberman or a Pitbull breed -- 20(i). Write a command to add a new visit to the database -- 20(ii). Write a command to update that new visits billed amount by 30%. (Use a formula expression. Don't calculate and then hard code the new rate) -- 20(iii).Write a command to delete the new specialty Note: Queries that do not return sufficient data will be marked as wrong i) All queries must generate some output ii) Queries with explicit sequencing (order by) must return a minimum of 3 rows iii) An aggregate query must have at least one row of output that is using at least 2 input rows (e.g. a count of 2, not 0 or 1) iv) Use column aliases where appropriate. v) Suppress duplicate rows where appropriate for output based on your actual data even if not specifically requested in the question. Have one group member submit a Zip file (not RAR) thru Blackboard that will contain the following files: i) A text file containing names and student ids for the group. ii) The mdf and log files of the database as modified with your test data. (Note: to copy or zip these database files they must be detached or offline. To detach a database close all active tasks in Management Studio. After selecting the database from the directory first on the short cut menu (right click) choose “refresh” then “tasks’ and then “detach”.) iii) The SQL file containing your answers (with the questions) to the queries.